SUM of Only Parents in Budget Sheet
Options
Hello! I've created a budget sheet with sub items. I figured out how to SUM the Children under a Parent line but what is the simplest way to SUM only the Parents for a Total that does not include both Children and Parents? Thank yo!
Answers
-
If your budget hierarchy has the top level node as the name of the budget/project then you apply the exact same logic to the column at the top level node. Use the same formula =SUM(CHILDREN()), it will only calculate the SUM of only its immediate children.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!