Formulas Including New Rows
Hi,
(Sorry if this has already been asked and resolved, I couldn't find anything).
I currently use smartsheet for our team's training log. In doing so, there are several columns that require numerical data that I would like to keep track of.
Right now I use SUM (manually) each time someone fills out a new form, but I wanted to know if there was a way for the cell to automatically include the newly added rows from the forms?
Comments

You'll want to count the entire column range of your column, for example:
=SUM([# Club Staff]:[# Club Staff])

Thank you so much for responding Shaine!
When I entered that formula, it's saying "#CIRCULAR REFERENCE"  is there something else I should have done?

Hi,
That means that you've got this formula in a column that contains another formula that references its data in some way. (Formulas can't reference one another's data in this way or you'll create a circular reference.)
A couple of ways to potentially combat this:
 Move the formula to another column.
 Reduce the range such that it references cells 1  x (where x is the bottom of your range).
 Create hierarchy in your sheet and use a SUM(CHILDREN()) formula instead. More on hierarchy here: https://help.smartsheet.com/articles/504734hierarchyindentingoutdentingrows
On #2, you'll need to make sure that you're adding new rows BELOW row 1, somewhere in the range, or you'll run into the same issue with the range not expanding.
A function's range won't expand when you add new rows above or below it.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 348 Global Discussions
 199 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 455 Show & Tell
 28 Member Spotlight
 1 SmartStories
 282 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!