H
H
Hattori_Hanzo2020-06-02 09:53:38
Google Sheets
Hattori_Hanzo, 2020-06-02 09:53:38

How to number responses in google form?

I have a Google Form with an associated Google Spreadsheet.

Question: how to create automatic numbering of answers in a Google spreadsheet?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander Ivanov, 2020-06-02
@Hattori_Hanzo

The simplest thing you can do is to add the formula on the first line in the adjacent column where the Form saves the answers.
For example,
=ARRAYFORMULA(ROW(A:A) - 1)
Slightly more difficult
={"Номер ответа";ARRAYFORMULA(ROW(A2:A) - 1)}
Other methods will require scripts. If your respondents do not change their answers, then the actual number is the serial number of the entry in the Table

={"Номер ответа";ARRAYFORMULA(MATCH(A2:A;SORT(A2:A;1;1);0))}

5ed603af049ba412426285.png

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question