(solved) Easy IF formula to identify blank fields


This should be an easy one for you experts :frowning:
I try to write a formula for the following case:
I want to write the Value “Team” in a Field1 IF Field2 And Field3 And Field4 are not empty!

PLEASE help me!


IF(AND(1,2,3), 'Team').

Of course change the 1,2,3 to your actual field names.


no blank() check required? I’ll try …


Checking 3 not blank fields is the same as checking the 3 exist.


Works great … lesson learned. Thanks so much!