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
Check out the Formula Handbook template!