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
 Smartsheet Customer Resources
 61.4K Get Help
 325 Global Discussions
 183 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 127 Brandfolder
 154 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!