Using Hierarchies When Tracking Completion

I'm in the process of creating a tracker for an audit process. The sheet has multiple layers of hierarchies (i.e. 1, 1.1, 1.1.1). I'm trying to create a formula and workflow based on the parent level. Individuals will check "Complete" through automated update requests and a notification needs to be sent out to management when a full clause is completed. Any help is appreciated!
Best Answer
-
Hi @cmcneillyjci ,
This formula will enter "Parent Complete" if the children are checked complete: =IF(COUNT(Children({complete]@row)) = COUNTIF(Children([complete]@row),=1), "Parent Complete", "").
Obviously you can change the response to whatever you'd like. Place the formula in a new column on the parent rows. You can then use the presence of the response to trigger an alert in an automatic workflow.
This isn't a perfect solution but maybe it gets you started in the right direction. Good luck.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
Hi @cmcneillyjci ,
This formula will enter "Parent Complete" if the children are checked complete: =IF(COUNT(Children({complete]@row)) = COUNTIF(Children([complete]@row),=1), "Parent Complete", "").
Obviously you can change the response to whatever you'd like. Place the formula in a new column on the parent rows. You can then use the presence of the response to trigger an alert in an automatic workflow.
This isn't a perfect solution but maybe it gets you started in the right direction. Good luck.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
It worked! Thank you!
-
Good morning, Thank you for using the Community. Hope to see you again.
Be well,
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives