The Community will be undergoing maintenance on Saturday January 11 at 11:59pm - Sunday January 12 at 11:59pm EST. For assistance during this time, please visit our Help Center.
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!