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!