Parent child sum formula help
I need some assistance with a formula. The requirements are:
if a row is a parent, then sum the values of its child rows in column A
If the row is a child, ""
if the row is not a parent AND is not a child, then return the value in column A for that row.
I have tried numerous permutations, some of which get close, but none that work.
Answers

I believe you will need a helper column, called "children" or whatever you want.
in that column you will have a column formula, =count(children()), and you will use those results to determine if you are in a child row or a parent row

I think this is does what you are looking for where cost represents your column A:
=IF(COUNT(CHILDREN(cost@row)) > 0, SUM(CHILDREN(cost@row)), IF(COUNT(PARENT(cost@row)) > 0, "", cost@row))
Your scenario doesn't mention what to do with the value in column A on the parent row when there are children. Is it to be included in the SUM as well?
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 349 Global Discussions
 199 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 455 Show & Tell
 28 Member Spotlight
 1 SmartStories
 282 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!