How do I write a formula for finding the sum of all the rows below the parent?
I am wanting to take all the information that will populate in rows 2 and down to add together under Part Cost to create a sum. How can I do this?
Answers

@Rebecca Dudley You can put a formula like this in a parent row to gather data from children rows.
=sum(children())

I do have that currently in there, but for sheets that have information, it is not populating a sum for them. Do I need to create a new parent row?

I would probably need to see a screenshot..
Is the sum data in the same column that you have the formula in the parent row?
If it's in a different column, you may need to modify for example:
=sum(children(part@row))

The Part Cost, Labor Cost, and Total Cost all have the =sum(children()) in that blue row. I had previously copied this sheet from an original. Could that be a problem as well?

I figured out that I had not indented the children rows. All fixed!

@Rebecca Dudley okay glad you found that! I was going to ask you that question next 😂. Let me know if you need anything else.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.2K Get Help
 360 Global Discussions
 199 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!