RYG balls on status show green if complete
Options
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
Comments
-
=IF([% Done]8 = 1,"Green", IF(TODAY() - [End Date]8 > 0, "Red", IF(TODAY() - [End Date]8 > -3, "Yellow", "Green")))
Give this a try...