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