Help

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

Topic Labels: Formulas
Solved
Jump to Solution
1720 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