Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 17, 2024 06:47 AM
I'm using this formula in a Deadline Alert column:
IF({Deadline} < NOW(), "Late", IF(IS_SAME({Deadline}, TODAY(), 'day'), "At Risk", "On Time"))
I have a separate Status Column to mark tasks Done. Is there a formula to show "Done" (instead of "Late") in the Deadline Alert column when "Done" is selected in Status?
Solved! Go to Solution.
1 Solution
Accepted Solutions
Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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"
)
)
)
Reply
2 Replies 2
Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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"
)
)
)
Reply
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 17, 2024 04:49 PM
Thanks so much @TheTimeSavingCo!
Reply