Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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

1 Answer 1

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


Perhaps you need to do something with the number in column C?

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 at 15:51
@JacobJanTuinstra Um... I edited this in the hope it would become an answer to the question. –  Normal Human Jun 6 at 16:47

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.