This is on a custom object that looks up to Child and Mother Contact Records. I want to have the Checkbox Active MCH checked as true UNLESS:
The child is over 5 years old OR is deceased. The Deceased Checkbox is on the Contact Record.
Here's what I have: IF(Child_s_Age__c = "Over 5",FALSE,TRUE)
Where the child's age field is calculated from the birthdate of the child.
Now, I need to add, if the child's age is over five OR the deceased checkbox on the child's contact record = True.
Sorry, formulas are not my strong point here.
11 answers
Trish, just for testing sake, can you give this a shot?
IF(
OR(
Child_s_Age__c = "Over 5",
Contact_Lookup__r.Deceased__c = TRUE
), FALSE, TRUE
)
