How do I reference one cell to the left?

Will Kremer

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?

Paul Newcome

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.

Schmic52

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?

Paul Newcome

@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.