IF OR Statement with Multiple Fields

[Bryan_Conetta]

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

[Alexey_Gusev]

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