How do I reference one cell to the left?
In Excel I use this formula =INDIRECT("RC[-1]",0)+1 to create a row that could look like 23, 24, 25, 26, etc... for example, but this formula does not work in Smartsheet. I cannot use an absolute reference because I need the value for each cell to be one greater than the cell to the left, instead of one greater than the initial cell referenced. Is there a way to reference a cell by position in this way?
Answers
-
If you manually enter the first number into the first cell, you can enter this into the second cell
=[First Column]@row + 1
and then dragfill across the row.
-
This just added 1 to the value in [First Column]@row.
I checked Create a Cell or Column Reference in a Formula but I could not find the solution.
Any further suggestions?
-
@Schmic52 Are you able to provide screenshots for reference to what you are wanting to accomplish? It sounds like the above solution worked as it was supposed to work (adding 1 to the value), but it sounds like you are wanting something different.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!