Skip to main content

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")
 

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") 

Reply


Terms & Conditions