I want to create a formula checkbox field that looks to see if ANY of 3 fields has blank values. Date field Date field Currency field If any 1 of these 3 is blank, mark as true

Pro Tip: Whenever you use an ISBLANK Function in a Formula Field make sure you select "Treat blank fields as BLANKS" not zeroes, or it will misfire

Formula - check for missing field values

I want to create a formula checkbox field that looks to see if ANY of 3 fields has blank values.

If any 1 of these 3 is blank, mark as true

3 réponses

Steve Molis (You Owe Me a Beer, Inc.)
13 nov. 2024, 16:07
Pro Tip: Whenever you use an ISBLANK Function in a Formula Field make sure you select "Treat blank fields as BLANKS" not zeroes, or it will misfire

Ajouter un commentaire

0/9000