How Do I add Sum(Children) at the bottom of the children rows
Hi,
How do I use the =Sum(Children) function in Smartsheet to sum child rows and display the total at the bottom.
I usually create a parent row, then add rows beneath it, indent them and add the formula =Sum(Children) to the parent row to calculate the total. However, that structure was confusing for users, and they preferred seeing the title at the bottom rather than the top. How can I do that?
Best Answer
-
Hi @User251
Unfortunately, you can't. Unless the whole calculation is manual where you are having a formula like =SUM([Column1]1:[Column1]20) where 1 and 20 represents the row numbers and Column1 represents the name of the column in which you've the values to sum/
Thanks,
Aravind GP| Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Answers
-
Hi @User251
Unfortunately, you can't. Unless the whole calculation is manual where you are having a formula like =SUM([Column1]1:[Column1]20) where 1 and 20 represents the row numbers and Column1 represents the name of the column in which you've the values to sum/
Thanks,
Aravind GP| Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
-
@AravindGP Thank you!
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!