Mar 17, 2024 06:47 AM
Solved! Go to Solution.
Mar 17, 2024 08:23 AM
I think if you put that IF in front of your existing ones it'd work fine:
IF(
{Status} = "Done",
"Done",
IF(
{Deadline} < NOW(),
"Late",
IF(
IS_SAME(
{Deadline},
TODAY(),
'day'
),
"At Risk",
"On Time"
)
)
)
Mar 17, 2024 08:23 AM
I think if you put that IF in front of your existing ones it'd work fine:
IF(
{Status} = "Done",
"Done",
IF(
{Deadline} < NOW(),
"Late",
IF(
IS_SAME(
{Deadline},
TODAY(),
'day'
),
"At Risk",
"On Time"
)
)
)
Mar 17, 2024 04:49 PM
Thanks so much @TheTimeSavingCo!