Help

(solved) Easy IF formula to identify blank fields

1180 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Raik_Brauns
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

4 Replies 4

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!