This should be an easy one for you experts 
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!
Page 1 / 1
IF(AND(1,2,3), 'Team').
Of course change the 1,2,3 to your actual field names.
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!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.