Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

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

Topic Labels: Formulas
Solved
Jump to Solution
138 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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"
    )
  )
)

Solved! Thank you so much, Jeremy.

Just needed MORE NESTS