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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!