Formulas and data

I have a fairly simple sheet used to track travel costs by subcategory and estimate/actual comparisons. I want to add new data lines into the sheet inside the subcategories and have the subcategory total formulas automatically adjust to the larger data table. When I try it the formula data range remains static, referencing the original data row #s, not the expanded set. How can I make the ranges auto-adjust in a formula?

Find more posts tagged with

Formulas

Comments

Jay Bautista

Use the function =SUM(CHILDREN)

https://www.smartsheet.com/blog/mark-mader/stop-losing-your-children-pipelines-and-do-lists

Travis

Jay is correct! The CHILDREN() function will always look to the child rows, even if you add more child rows after adding the formula (when added to a parent).