Multiple IF Statments

Options

Hi Smartsheet Community,

I have a question regarding multiple IF statements.

  • What I am trying to accomplish: I am trying to put text in a box if the days are greater than or equal to the number of days since completion 0-30 Days, 31-60 days, 61-90 Days, 91-120 Days, 121-364 Days, 365+ Days.
  • Current Formula: =IF([Total AR Days]@row > 365, "365+ Days", IF([Total AR Days]@row > 120, "121-364 Days", IF([Total AR Days]@row > 90, "91-120 Days", IF([Total AR Days]@row > 60, "61-90 Days", IF([Total AR Days]@row > 30, "31-60 Days", "0-30 Days"))))))


Question: It is not working and coming up "unparseable" hoping you could lend some assistance.


Thank you so much for your help!


Will

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!