Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

My formula not working

Topic Labels: Formulas
231 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Something strange with my formula. It was working fine earlier, but not now (something changed?)

IF({Date} >= 365, “ :x: ”,
IF({Date} <= 0, “ :x: ”,
IF({Date} < 334, “ :white_check_mark: ”,
IF({Date} >= 335, “ :warning: ”))))

When field is empty or 0 (zero) it still show :white_check_mark:
Why?

1 Reply 1

I don’t think the condition <=0 would catch an empty field, so I’d try inserting right thereafter:
IF({Date} = BLANK(), "X",
{Date} seems to be the integer type. If that comparison weren’t accepted then try even:
IF({Date} = null, "X",