Google spreadsheet – how to add unique id?

This formula is what you want:

=arrayformula(if(row(A1:A)=1,"UNIQUE ID",if(len(A1:A)>0,98+row(A1:A),iferror(1/0)))

Do not try to use ScriptProperties. It is very problematic and you’ll regret.

This entry was posted in Uncategorized. Bookmark the permalink.

Leave a comment