Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Make something say DONE when done, OVERDUE when overdue, Approaching within one week

Topic Labels: Formulas
Solved
Jump to Solution
1848 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Arlo_James_Jack
4 - Data Explorer
4 - Data Explorer

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??

1 Solution

Accepted Solutions
Jeremy_Oglesby
14 - Jupiter
14 - Jupiter

Hi @Arlo_James_Jackson,

I believe this should do what you want:

IF(
  {Done} = "Yes", 
  "Done",
  IF(
    TODAY() > {Date Due},
    "OVERDUE",
    IF(
      {Days} < 5,
      "Soon"
    )
  )
)

See Solution in Thread

2 Replies 2
Jeremy_Oglesby
14 - Jupiter
14 - Jupiter

Hi @Arlo_James_Jackson,

I believe this should do what you want:

IF(
  {Done} = "Yes", 
  "Done",
  IF(
    TODAY() > {Date Due},
    "OVERDUE",
    IF(
      {Days} < 5,
      "Soon"
    )
  )
)
Arlo_James_Jack
4 - Data Explorer
4 - Data Explorer

Solved! Thank you so much, Jeremy.

Just needed MORE NESTS