Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Formulas and data

John Stark
edited 12/09/19 in Archived 2016 Posts

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?



This discussion has been closed.