Blank() with OR formula | Airtable Community

Hi, I have the following formula that works by displaying a ! when col1 is empty:

IF({Col1} = BLANK(), “!”, “”)

However I would like to add OR statement so that the ! is displayed if either Col1, Col2 or Col3 have no entries.

I have tried varying different ways with no luck, such as:

IF({Col1} or {Col2} or {Col3} = BLANK(), “!”, “”)

Thanks in advanced.

Page 1 / 1

Hi Oliver.

Here’s the formula:

IF(NOT(AND(Col1,Col2,Col3)),"!")

If all three fields are not blank, then show nothing.

If at least one of the fields is blank, then show “!”.

This is an equivalent but longer formula:

IF(OR(NOT(Col1),NOT(Col2),NOT(Col3)),"!")

Thanks Claudio,

Used your formula to come up with following that works for me:

IF(OR(Col1,Col2,Col3),"", “!”)

Thanks again Olly

Sign up