Having overall sheet health based off of parent and child row?
Hi - I know this has been asked and answered similarly, but I am struggling with actually implementing the formulas.
I have created a simple sheet that I would like to have a visual R/Y/G/Gr marker at the top of the sheet that is a roll up of the all of the parent rows below. I am basing the formula structure off of this community response: https://community.smartsheet.com/discussion/70069/how-can-i-get-parent-row-roll-up-of-child-tasks-health-status.
End result would ideally be that I could have several sheets that are using the same template. From there, the visual health status could be displayed onto a dashboard. Is this even possible? And if so, is it possible to have it be averages as opposed to overall ">1,"Red""? Could it be based off the four main rows average?
Here is a link to the sheet: https://app.smartsheet.com/b/publish?EQBCT=248c7046c2f9480eb93c35eaf5a1f994
Answers
-
I actually found a WorkApps Template (Project Schedule) that has what I need. Thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!