Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Blank() with OR formula

Topic Labels: Formulas
541 2
Showing results for 
Search instead for 
Did you mean: 

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.

2 Replies 2

Hi Oliver.

Here’s the formula:

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:

Thanks Claudio,

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

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

Thanks again Olly