Generate consecutive numbers for Google Forms Responses in Google Sheets

In this tip, we will learn how to create an automatic sequence of numbers in Google Sheets, each time a new Form Response is recorded.

We will learn 2 ways of doing it, first with formulas, then with a simple Google Apps Script code

➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions

➤You can also subscribe to the channel where you´ll find a new Sheets video every week.

Here are some of the places where you can follow and support me:

Any suggestion, question or insights, feel free to comment below

[AalimOnlineOfficial]

You can use array formula to sequence function fir running serial number

[EliPatinoAve]

thank you for this! Is there a way to insert that consecutive ref # into the confirmation email that gets sent out upon submission?

[krpdim]

Excelent video! where I work we are moving too GoogleWorkspace from Office so it has been a little difficult learning what we can do and can't. First time using Apps Script, Thanks!
Question: Is there a way to make that consecutive number to have letters? like A24X001, A24X002, etc?
gracias/Thanks, again!

[rohank]

Bro can you do a video how to change Google sheets valuse (which was given using Google forms)using another Google form response

[YekYeu-kr]

Hi thank you for this wonderful video, may i ask how can i make the sequence number like 3 digits?
example:
i want it to be
001
002
003....

instead of
1
2
3...

is it possible?

Hoping for your response thank you

[BradWilson-gfny]

Hi the code is great but if you sort the sheet and a lower number is in the last row when adding a new form response it takes the new consecutive number from the last row which adds a new sequential number but not the actual last number if you know what i mean. could you help with this as we sort the sheet into an order that suits us

[JoeyMemmott]

ReferenceError: sheet is not defined
at addCode(Code:6:3)