HEALTH SYMBOL OVERALL FORMULA
Hello...Still having issues with the overall health formula. I am trying to establish a formula that will do the following:
Overall Health Formula Need:
Green = More than 80% of tasks health are green
Yellow = More than 20% and less than 80% of tasks health are yellow
Red = More than 5% and less than 20% of tasks health are red
Individual Task Health
Green= Task is complete
Yellow= Task is in progress and not past due
Red=Task is in progress and past due or delayed or at risk
Blue= Task is not started
Gray= Task is cancelled
Any assistance is greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!