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!