Auto Increment as Formula is copied to the right

tesman284

I have a formula that is referencing another sheet, and I would like a way to copy this formula in column "Rating 1"

=IFERROR(INDEX({Rating_Avg_Selection}, 2), "No Data")

in the same row to the right (next column), and reference the next number within the formula, which will point to the correct row where the data resides. The formula above is referencing "2" and when I drag this to the next column to the right, I want it to increment to "3" like this example in column "Rating 2"

=IFERROR(INDEX({Rating_Avg_Selection}, 3), "No Data")

This is an example row I have in my worksheet, and I have numerous rows that I will have to update manually if there is no workaround (OR hopefully there is a way to update my formula)

Thank you in advance.

tesman284

Paul, thank you for the response. I hoped this was not the only workaround, but it seems it is. I will have to submit this as a new request (unless it already has been submitted). It can be done in Excel, so hopefully it will eventually be a part of Smartsheet.

Paul Newcome

The only way to get this to work would be to add another row (for the sake of this example I will use row 1) with the numbers manually populated (if you enter 1 and 2, you can dragfill to increment these) and then reference that row in your formula.

=INDEX({Range}, [Column Name]$1)

tesman284

Paul, thank you for the response. I hoped this was not the only workaround, but it seems it is. I will have to submit this as a new request (unless it already has been submitted). It can be done in Excel, so hopefully it will eventually be a part of Smartsheet.