Formulas and data

John Stark

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?

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).