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?
Help Article Resources
Check out the Formula Handbook template!