How do I use =SUM(CHILDREN()) correctly?
Good afternoon,
I'm trying to use the sum children function for smartsheet designed for budgets. I was able to sum the initial 5 rows correctly, then added 6th row to test the children function. I put in the new formual =SUM(CHILDREN()) and when I press enter, the value turns from the original budget price to zero. Any thoughts on what I am not doing correctly? Thank you for your help.
Best Answers

You need to indent the rows. To the left of the font selector theres arrows left and right. Put your cursor in a cell in row 2, then select the one that shows as selecteble. You'll need to do this will all rows you want to calculate on, you can highlight them and do them at once however.

Yep. Indenting your rows as @L@123 has suggested will then make your formula work. Here is more on hierarchy in smartsheet:
Answers

Are your numbers you are trying to sum actually numbers? You can tell because they will float to the right of the cell of they are. A screenshot would help us understand better where and how you are trying to do this. Is that possible?

Hi Mike, thank you for your input. They are actually numbers but simply made up for testing purposes, please the attached screen shots. The first screen shot highlighted with green at the top right is simply the SUM formula which works perfectly fine. The second screenshot with the blue highlighted area is where the CHILDREN formula is not working.
Thanks for your help.

You need to indent the rows. To the left of the font selector theres arrows left and right. Put your cursor in a cell in row 2, then select the one that shows as selecteble. You'll need to do this will all rows you want to calculate on, you can highlight them and do them at once however.

Yep. Indenting your rows as @L@123 has suggested will then make your formula work. Here is more on hierarchy in smartsheet:

Thank you both, that info was most helpful and I was able to figure it out. Again much appreciated.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 200 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 446 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!