Answer the question
In order to leave comments, you need to log in
Why is a new row created in the table after the response is written?
Good day! Created a form through google forms, but there is a problem when saving the data. At first, everything is saved on the answer sheet, but there is too much information. Therefore, I created a sheet of summary information, but for some reason a new line is always created there, i.e. should be cell A3, and became A4.
Answer the question
In order to leave comments, you need to log in
Add a B1
formula to the cell. Delete
=INDEX('Ответы на форму!A:A')
everything else in the column B2:B
!
Explanation of reasons in the article How to stretch the formula when answering Forms in Sheets?
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question