T
T
timur_khabibullin2021-07-28 08:00:20
Google Sheets
timur_khabibullin, 2021-07-28 08:00:20

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.

6100e46238251502451334.png

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Alexander Ivanov, 2021-07-28
@timur_khabibullin

Add a B1formula 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?

B
BasiC2k, 2021-07-28
@BasiC2k

Well, then everything works correctly. When submitting a Google form, a new row with data is created. You need to process the received data on another sheet.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question