Nested IF Statement with RYGB Balls

edited 12/09/19 in Formulas and Functions

Hi, I'm trying to setup a nested IF statement to do the following:

If DONE is checked then change the Status to Blue.

If Due Date is more than 8 days out then make it Green.

If Due Date is 7 days or less then make it Yellow.

If Due Date is TODAY or in the past make it Red.

This is what I have so far but it is not working.

=IF(Done1 = 1, "Blue", IF([Due Date]1 <> =TODAY(-7), "Green", IF([Due Date]1 > TODAY(-8), "Yellow", IF([Due Date]1 >= TODAY(0), "Red"))))

Any help would be greatly appreciated.



  • Brian W
    Brian W ✭✭
    edited 12/20/18

    You’re almost there, but your calculations are just a little off. Try this:

    =IF(Done1 = 1, "Blue", IF([Due Date]1 > TODAY(8), "Green", IF([Due Date]1 > TODAY(), "Yellow", "Red")))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!