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.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!