Formula does not resolve the last True in nested IF

Platform discussions Special workflows & use cases
1

I am using the following formula with some nested IF. The last entry “ON TIME” results in een 0 instead of ON TIME. What am I missing here?

IF(
{Target Date}=“”, “NO TARGET DATE”,
IF(
{Status}=“CLOSED”, “CLOSED”,
IF(
{Target Date} < FORMAT_DATE(TODAY()),WORKDAYS(TODAY(), {Target Date})
,“ON TIME”
)))

2

@MatthewGRCguard

The innermost IF() should read:

IF({Target Date} < FORMAT_DATE(TODAY(),"YYYY-MM-DD"),
  WORKDAYS(TODAY(), {Target Date}),
  "ON TIME"
)

Jim - The Monday Man
Get Custom Apps, Integrations & Automations for monday

1 Like