Creating a formula to calculate percent from the parent rows
I am trying to create a formula for a cell where it collects the percentage of all the % values in the parent rows below it. Not only the current parent rows, but also any new ones that are added. The parent rows are currently averaging the percent in the sub rows below it. In this case, I want the total percent to be in the purple row. Thank you!
Answers
-
Hi Alicia,
I believe this is the formula you will want to paste into the purple row:
=AVG(CHILDREN())
This will tell Smartsheet you'd like the average percentage of all existing and new child rows in your hierarchy.
Here is a quick example I put together showing this formula:
The top image displays the formula in the cell and the bottom image shows the calculation by the formula. Hopefully that helps!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!