How to transfer data from google forms to google sheets?

E

Eremey Ikashev2020-01-01 08:31:13

Google Sheets

Eremey Ikashev, 2020-01-01 08:31:13

I created a form and linked it to a table, a sheet with answers to the form appeared in the table, I (='Ответы на форму (1)'!C1)tried to transfer data from the sheet with answers to another sheet using the formula, then I just stretched this formula over the entire table, but when it appears in the answer sheet a new line, then all formulas change the cell values by 1 below, i.e. if it was (='Ответы на форму (1)'!C1), then it became (='Ответы на форму (1)'!C2). How can I make these values not change without using fixing cells with "$" or how can I fix 1000 cells at once with "$"?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

G

Grigory Boev, 2020-01-04
@ProgrammerForever

This should help. Strings in INDIRECT () are not affected by all the autocorrect tricks.

=arrayformula(ДВССЫЛ("'Ответы на форму (1)'!c1:c)"))