Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I created a Google form and a spreadsheet associated that form. On the spreadsheet there are two columns by default. A is Timestamp and B is Untitled question. Now I want to create another column in C that counts the form response's number (like the spreadsheet rows on the left) automatically when somebody send a submission.

Is there any way to do this?

enter image description here

share|improve this question
Comment in the original answer by @ghozx Perhaps you need to do something with the number in column C? – Rubén Aug 5 '15 at 23:57

You seem to be asking another question since the answer to your question is to simply look at the row number and subtract 1: that is, use the formula

share|improve this answer
This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post. – Jacob Jan Tuinstra Jun 6 '15 at 15:51

You could use =ROW()-1 as was proposed in the answer by @ghozx. It's worth to say that this will require to fill down the formula manually or by a script after one or more responses be submitted.

An alternative is to use the following formula in cell C2:


The above formula will return an array that will be of the same size of the number of responses, displaying the response number for each response. In other words, when a respondent submit a new response, the related row in column c will automatically display the response number.

share|improve this answer
Shorter version: =Filter(Row(B2:B)-1,Len(B2:B)) – ᴡᴏʀᴅs Aug 6 '15 at 1:30

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.