I created a form and linked it to a table, the table has a sheet with answers on the form, I using the formula

`(='the Answers to the form (1)'!C1)`

tried to transfer the data from the worksheet with the answers on another sheet, then I simply pulled this formula across the table, but when the answer sheet appears as a new row, all the formulas change cell values below 1, i.e. if `(='the Answers to the form (1)'!C1)`

, it became `(='the Answers to the form (1)'!C2)`

. How to make these values did not change without the use of fixation of cells using "$" or how you can lock in 1000 cells at once with "$"? asked April 4th 20 at 00:28

1 answer

answered on April 4th 20 at 00:30

This should help. On-line in **the indirect**() all the tricks avtosalony do not apply.

`=arrayformula(indirect("'Answers to the form (1)'!c1:c)"))`

Find more questions by tags Google SheetsGoogle Forms