You need to sign in to do that
Don't have an account?
BhavanaSingh
Trailhead Using Basic Logic in Checkbox Formulas NOT() example
This example says that if any fields are not filled in, the contact complete checkbox should remain unchecked
!(ISBLANK(FirstName) && ISBLANK(LastName) && ISBLANK(Phone) && ISBLANK(Email) && ISBLANK(MailingAddress))However, the way it is coded, the expression inside the () will return No if any fields are not filled in and then and a NOT of that will return a yes
The idea is you would map out table with Firstname, Lastname, Phone, MailingAddress, etc across the top, and then fill out all the combinations of 0 (or false conditions) and 1 (or true conditions), and then come to a conclusing how your logical statement should look like.
If you wrote out a truth table for this condition, you would notice that the term "ANY" really refers to an OR condition, instead of an AND condition which relates to "ALL" criteria.
In other words, if you used || instead of &&, you would likely get the desired effect.
Also, I prefer to write it out as OR(ISBLANK(Firstname),ISBLANK(Lastname),ISBLANK(Phone)...... instead of using the || operator, as it takes fewer characters to implement.
Let me know if that helped you out.