function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Kevin CiceroKevin Cicero 

Data Type = Formula and Output Type = Checkbox

checkbox field on Team Member objectAdded new Custom field "Include in Payroll File" on Team Member object. Need help with Formula data type and Checkbox output type to identify employees who meet the following requirements: are in the US, are Full Time, are Active employees and have a start date after 1/1/2018.
 
No syntax errors, but the checkbox on Team Member record is blank: (fHCM2__Has_Left__c = 'FALSE') && (fHCM2__Country__c = 'USA') && (fHCM2__Current_Employment__r.fHCM2__FTE__c >= 1) && (fHCM2__Current_Employment__r.fHCM2__Start_Date__c >= DATE(1,2,2018))
Andrew GAndrew G
Hi Kevin

1.  DATE formula using DATE(Y,M,D) 
2.  Try rewrite with the AND logic formula e.g.
  
AND(
  (fHCM2__Has_Left__c = 'FALSE'),
  (fHCM2__Country__c = 'USA'),
  (fHCM2__Current_Employment__r.fHCM2__FTE__c >= 1),
  (fHCM2__Current_Employment__r.fHCM2__Start_Date__c >= DATE(2018,1,2))
)
I have found that this format works better for Formula for Checkbox, but if you like try it first with the DATE formula fix.

HTH
Andrew
Kevin CiceroKevin Cicero
Thanks Andrew! This worked just fine
megha lovemegha love
If you want to know right away if an account has at least 500 employees on it, To take full advantage of the checkbox formula data type, you need some basic logical tools. Copy the following code snippet and paste it into the formula editor. It also helps anyone else who has to understand or update the formula later. by GBWhatsapp (https://gbwhatsapp.fun/) 

You can find more related information on official https://trailhead.salesforce.com/en/content/learn/modules/advanced_formulas/checkbox_logic_formulas