Skip to main content

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

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

Reply


Terms & Conditions