📑 Generating an ID Column in Google Sheets

Bookmarked

Here's a better but more complex solution. 👇

Use this formula in cell A2 for a more robust auto ID generator that will account for any blanks and still assign the correct column IDs:

=ArrayFormula(SEQUENCE(MAX(ROW(B2:B)*(B2:B<>""))-1))

— Ben Collins (@benlcollins) August 3, 2022

Ben Collins provides a formula for generating a list of IDs or numbers dependent on how many items are in the list using the Sequence formula:

=ArrayFormula(SEQUENCE(MAX(ROW(B2:B)*(B2:B<>""))-1))

Leave a Reply Cancel reply