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/absolute-record-references
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/absolute-record-references
-
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
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!