Formula Autofill Issue
I'm having an issue with autofilling formulas when I add new rows....
I have a sheet with some columns that contain formulas that only reference other cells contained within that row.
When I insert a new row and enter data into the primary column those formulas autofill into that new row like they are supposed to.
I have other columns that have formulas that contain references to particular cells in other rows. These formulas are not autofilling when I add new rows.
Is this a temporary glitch or a limitation of Smartsheet?
Best Answer

I think it should work, but I have a question. Are you using Absolute References in the formulas that reference particular cells in other rows? if not, then I think what you may be running into is that the formulas are making the cell references dynamic and moving them away from your target cell.
To use an absolute reference add a $ to the column name and row number.
https://community.smartsheet.com/discussion/293/absoluterecordreferences
Answers

I think it should work, but I have a question. Are you using Absolute References in the formulas that reference particular cells in other rows? if not, then I think what you may be running into is that the formulas are making the cell references dynamic and moving them away from your target cell.
To use an absolute reference add a $ to the column name and row number.
https://community.smartsheet.com/discussion/293/absoluterecordreferences

It should be working. All of my sheets are. You may want to contact Support.

Yes it looks like the lack of absolute references was the issue. That's going to make my programming of this sheet a lot more tedious but at least its working now. Thank you

No problem.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.4K Get Help
 364 Global Discussions
 200 Industry Talk
 429 Announcements
 4.4K Ideas & Feature Requests
 137 Brandfolder
 129 Just for fun
 128 Community Job Board
 446 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!