Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

My formula not working

Topic Labels: Formulas
765 1
cancel
Showing results for 
Search instead for 
Did you mean: 
admin2
4 - Data Explorer
4 - Data Explorer

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
Grunty
7 - App Architect
7 - App Architect

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",