Jan 07, 2021 02:06 PM
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?
Solved! Go to Solution.
Jan 08, 2021 04:27 AM
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.
Jan 08, 2021 04:27 AM
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.
Jan 08, 2021 10:22 AM
@Nick_Dennis exactly what I needed! Thank you sir!