You need to sign in to do that
Don't have an account?
Kevin Cicero
Data Type = Formula and Output Type = Checkbox
Added 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))
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))
1. DATE formula using DATE(Y,M,D)
2. Try rewrite with the AND logic formula e.g.
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
You can find more related information on official https://trailhead.salesforce.com/en/content/learn/modules/advanced_formulas/checkbox_logic_formulas