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!
(solved) Easy IF formula to identify blank fields
This topic has been closed for replies.
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 …
no blank() check required? I’ll try …
Checking 3 not blank fields is the same as checking the 3 exist.
Checking 3 not blank fields is the same as checking the 3 exist.
Works great … lesson learned. Thanks so much!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.