The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Oct 26, 2022 02:48 PM
So I have the following:
IF(
TODAY() > {Date Due}, “OVERDUE”
)
I have a Column named ‘Days’ for days left to do my task, so I made the following, using the nested IF tutorial:
IF(
TODAY() > {Date Due}, “OVERDUE”,
IF({Days} < 5, “Soon”)
)
I’m trying to figure out how to add my ‘done’ column to this but I keep on getting errors. So far I tried:
IF(
TODAY() > {Date Due}, “OVERDUE”,
IF({Days} < 5, “Soon”)
IF({Done} = Yes, “Done”)
)
but it says invalid. idk how to return text from a multiple choice??
Solved! Go to Solution.
Oct 26, 2022 04:24 PM
I believe this should do what you want:
IF(
{Done} = "Yes",
"Done",
IF(
TODAY() > {Date Due},
"OVERDUE",
IF(
{Days} < 5,
"Soon"
)
)
)
Oct 26, 2022 04:24 PM
I believe this should do what you want:
IF(
{Done} = "Yes",
"Done",
IF(
TODAY() > {Date Due},
"OVERDUE",
IF(
{Days} < 5,
"Soon"
)
)
)
Oct 26, 2022 05:02 PM
Solved! Thank you so much, Jeremy.
Just needed MORE NESTS