Sum of children while keeping column formula
In my sheet I have columns with formulas that I would like to keep as applied column formulas. I also categorize my row's by creating children under a labeled row. Within the labeled row I would like to Sum up the figures contained within the columns that have column formulas however when I try to do that, the system wants me to not keep it as a column formula but change it to cell formulas only.
Is there a way I can create a sum of Children while also keeping the column formula applied only to the children?
Answers
-
Hi @RamseyH
I hope you're well and safe!
Unfortunately, it's not possible now, but it's an excellent idea!
Here's a possible workaround or workarounds
- Add a so-called helper column where you calculate the sum of children and reference it in the parent in the other column.
Would that work/help?
I hope that helps!
Be safe, and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
This was helpful thank you! I will suggest this update to smartsheets.
-
Excellent!
Happy to help!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Based on this comment:
"Is there a way I can create a sum of Children while also keeping the column formula applied only to the children?"
It sounds like you already have a formula in the child rows and that you wan to just sum up the outputs of the formula in the child rows on each parent row. If that is the case, you shouldn't need a helper column. Just an IF formula that says if it is a child row, run the child row formula, otherwise SUM(CHILDREN()).
=IF(COUNT(CHILDREN()) = 0, child_row_formula, SUM(CHILDREN()))
-
This is fantastic! Exactly what I was looking for. Thank you for your help Paul!
-
Happy to help. 👍️
-
OK, so what if the child rows are not a column formula? In other words, I would want to always sum children in the parent, but the children's values are manually entered. It works with the date columns (start date, end date, etc) but I'd like it to take a similar action on other columns with numeric values.
-
@General Roper You would have to manually add the formula to each parent row.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 216 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!