Skip to main content

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


IF({Date} >= 365, “ ❌ ”,

IF({Date} <= 0, “ ❌ ”,

IF({Date} < 334, “ ✅ ”,

IF({Date} >= 335, “ ⚠ ”))))


When field is empty or 0 (zero) it still show ✅

Why?

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

Reply


Terms & Conditions