Nested IF Statement with RYGB Balls
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.