SUM of Only Parents in Budget Sheet


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!


  • Sameer Karkhanis
    Sameer Karkhanis ✭✭✭✭✭✭

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!