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
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 304 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!