RYG balls on status show green if complete

Randy Van Winkle

Hello I have a project tracker set up with a health button on each main category that shows green if the end date is more than 3 days in the future, yellow if within the 3 days and not complete, and red if not complete and end date in the past.  Right now it goes blank if the category is complete, but I would like it to show green if it is 100% as well. 

Here is the current formula: 

=IF([% Done]8 < 1, IF(TODAY() - [End Date]8 > 0, "Red", IF(TODAY() - [End Date]8 > -3, "Yellow", "Green")))

Any help appreciated

Paul Newcome

=IF([% Done]8 = 1,"Green", IF(TODAY() - [End Date]8 > 0, "Red", IF(TODAY() - [End Date]8 > -3, "Yellow", "Green")))

 

Give this a try...