Project health formula support
Hello, I am hoping for additional guidance on adjusting a formula. I have built out a lengthy project plan, I have 4 colors for health (green - on track; yellow - under control but there are a few concerns; red- at risk, grey - not started.). My project has many parent tasks with child tasks. All of these tasks roll up in to one master project health that should sync to the portfolio dashboard. A copy of the project follows, https://publish.smartsheet.com/a7e21cda28ea45a6aa2735303dbdd5ad My concern is that the formula doesn't account for grey status not seem to be averaging out correctly. Any help would be appreciated. Thank you!
Help Article Resources
Check out the Formula Handbook template!