RYG balls on status show green if complete

Options
Randy Van Winkle
Randy Van Winkle ✭✭✭
edited 12/09/19 in Smartsheet Basics

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

Comments