I have a spreadsheet that gets its data from a google form. I use a formula I found on a forum to generate a unique ID and assign it to every entry avoiding repetition. =arrayformula(if(len(B2:B);""&text(row(B2:B)row(B2)+2;"000")&RIGHT(VALUE(B2:B);3);iferror(1/0)))
The problem I have is that this ID is not permanent and changes every time I add or delete a row in between the first and last entry.
Could anyone help me? I want to avoid the ID to change every time I modify or delete a repeated entry.