I need a unique id displayed in my spreadsheet such as 0001 for the first response from the completed form and 0002 for the next one. I am trying to get it to automatically insert the numbers as form response is completed. I tried using =arrayformula( if( len(A1:A), ʺCAʺ & text(row(M1:M) - row(A2) + 1, ʺ000ʺ), iferror(1/0) ) ) however, I am getting a parsing error every time I use it. What am I doing wrong?
-- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
