Formula for Project Health
I'm a newer user and trying to create a few formulas to support the Health of Projects Due.
First, I'd like to use simple logic to provide row health.
- Not Started AND is greater than 14 days out from Due Date = Gray
- On Track to Deliver AND is 2 days out from Due Date - Green
- Delayed OR 2 days out from Due Date -Yellow
- Delayed AND/OR is Today - Red
- Complete - Blank
Next, I'd like to roll the average of the results of these ancestors up to the parent row.
Can anyone please recommend the best way to accomplish this?
Help Article Resources
Check out the Formula Handbook template!