My formula not working

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:

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

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.