Overall Project Health Formula
Hiya folks,
We want one field to show Overall Project Health. Ideally, we would figure out how to average the colors and/or tasks past due to return RYBG for the overall projects (about ~230) so that we can report it on a Dashboard. Any ideas on formula would be so appreciated.
Circular reference error formula in OPH row: =IF(Level@row = 0, =AVG(Health:Health), "")
Blocked error Health row formula: =IF(Summary@row = 1, "", IF(Level@row = 0, [Overall Project Health]@row, IF(OR(Status@row = "Complete", Status@row = "Cancelled/NA"), "Blue", IF(AND([Recommended Due Date]@row <= TODAY(), Status@row <> "Complete"), "Red", IF(AND([Recommended Due Date]@row <= TODAY(-3), Status@row <> "Complete"), "Yellow", "Green")))))
Grateful for any guidance others may have.
Best Answer
-
Hey Jess,
I think the best practice for overall project health is using the Weakest Link formula.
You can read more about it in this pdf:
Let me know if it helps.
The Real Smartsheet Enthusiast
Is there anything else we can help you with?
MASA Consult - Your Aligned Smartsheet Partner
Find us on LinkedIn!
Answers
-
Hey Jess,
I think the best practice for overall project health is using the Weakest Link formula.
You can read more about it in this pdf:
Let me know if it helps.
The Real Smartsheet Enthusiast
Is there anything else we can help you with?
MASA Consult - Your Aligned Smartsheet Partner
Find us on LinkedIn!
-
This is great, thank you so much!!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 304 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!