Skip to main content

IF OR Statement with Multiple Fields

  • November 8, 2023
  • 1 reply
  • 30 views
B
Forum|alt.badge.img+1

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

Alexey_Gusev
Forum|alt.badge.img+25

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

Terms & ConditionsAccessibility statement