Need IF Formula to ignore empty fields

[Maarten_VandenH]

Hi All, very new to this and looking for some help. I’m looking to quickly see if a briefing has been completed or if any fields have been left empty (to then later report on this).

Example I have 5 fields, if one of these fields is empty I want the output to be “incomplete”.

I have been trying with this: IF({Message Name}=BLANK(),“Incomplete”,“Complete”) but this only works for me with one field. Any way I can check multiple fields to see if one of them is empty?

[Nick_Dennis · Accepted solution]

Hi @Maarten_VandenHeuvel,
You should be able to accomplish this by wrapping the arguments in an OR() statement:
IF(OR({Field 1} = BLANK(), {Field 2} = BLANK(), {Field 3} = BLANK(), {Field 4} = BLANK()), "Incomplete", "Complete")

Hope that helps.

[Maarten_VandenH]

@Nick_Dennis exactly what I needed! Thank you sir!