Automated RYG ball issues
I have a sheet where I am using red, yellow, green and gray balls to indicate project health.
If the project is complete, the ball is gray. If the due-date is within the next 14 days, yellow. If due-date is today or in the past, red, and everything else green.
I must have something wrong somewhere, because the red isn't showing up as expected.
Here is a link to my sheet: https://app.smartsheet.com/b/publish?EQBCT=562b74cdaf124ac8b252a717caf3a170
And here is the formula:
=IF(ISDATE([Project Completion Date]1), "Gray", IF(TODAY() >= ([Project Due Date]1 - 14), "Yellow", IF(TODAY() >= ([Project Due Date]1), "Red", "Green")))
Any help would be appreciated. Thank you!
Help Article Resources
Check out the Formula Handbook template!