Answer the question
In order to leave comments, you need to log in
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
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))}
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question