Sign in to submit new ideas and vote
Get Started
We are aware that the yellow status bar is not showing for Ideas, even when logged in.

This has been reported to the website support team and we are looking into it. In the meantime, please add your votes from the list view or by commenting on that idea.

You can see Statuses by filtering the main list.

Formula to be copied and increment the column reference

Options

Allowing a formula that references another sheet, and to be copied via the drag function 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 dragged this to the next column to the right, it should increment to "3" like this example in column "Rating 2"

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

This is an example of the row in a worksheet

image.png

So when =IFERROR(INDEX({Rating_Avg_Selection}, 2), "No Data") is dragged to the next column, it will increment to =IFERROR(INDEX({Rating_Avg_Selection}, 3), "No Data") and continue increasing the "Number" within the formula.

Tags:
1
1 votes

Idea Submitted Β· Last Updated