Formula for RYGB Symbols using % Complete AND Due Date
I'm trying to create a formula in the "Health" column that will display RYGB symbols to indicate the following:
Blue = 100% (Complete)
Green = greater than 50% (In Progress)
Yellow = less than 25% (At Risk)
Red = 0% (Delayed)
I am to use the "% Complete" column AND "Actual Due Date" column to determine what the progress is on a project for higher ups to track easily.
As far as the Actual Due Date, I'm not sure how to incorporate it, if you can give me some ideas or direction it would be highly appreciated.
Help Article Resources
Check out the Formula Handbook template!