Help

IF OR Statement with Multiple Fields

Topic Labels: Formulas
552 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Bryan_Conetta
4 - Data Explorer
4 - Data Explorer

Hi - I am trying to build an IF(OR statement that returns a value if any of the fields are blank. The way it's currently written returns COMPLETE even though some fields are blank.

Here is what I have so far:

 
IF(OR({Premiere Project File - RBs}=BLANK(),{Delivery instructions}=BLANK(),{Final Viewing Link}=BLANK(),TRT=BLANK(),
"INCOMPLETE"),
"COMPLETE")
 
1 Reply 1

Hi,
Usually, BLANK is not used in Airtable, instead you can check with IF({Fieldname}, 'not empty' , 'empty' )
in your case (btw you closed OR bracket in a wrong place), I would do:
IF( AND( {Premiere Project File - RBs},{Delivery instructions},{Final Viewing Link},TRT ),
"COMPLETE","INCOMPLETE")