Hi!I’m going nuts on this one. Hope you guys can help a brother out. Every time a “new row” is created (on google sheet) I need to add on “column A” a “unique random number” on that new row created. I know I can set formulas on zapier, but I’m struggling doing so. There are a few issuesRandom number: If this formula is used each time that any kind of info is placed on the sheet, ALL numbers are “refreshed”. For me this doesn't work since I need to keep the original (first) number. I have set a value of “CR-0001-” on that column, so each time a new row is created, “CR-0001-” is placed (this is working just fine). Now. I need to place after this numer: 0001 then 0002 then 0003 and so on, for each “new row” created. I’m getting all the info from SHOPIFY (this I manage to do) so I just need to fill this column with this unique number. I hope I was clear, since english is not my first language. Thank you in advance!

Answer

Add a unique random number per row in Sheets

Hi!

I’m going nuts on this one. Hope you guys can help a brother out.

Every time a “new row” is created (on google sheet) I need to add on “column A” a “unique random number” on that new row created.

I know I can set formulas on zapier, but I’m struggling doing so. There are a few issues

Random number: If this formula is used each time that any kind of info is placed on the sheet, ALL numbers are “refreshed”. For me this doesn't work since I need to keep the original (first) number.
I have set a value of “CR-0001-” on that column, so each time a new row is created, “CR-0001-” is placed (this is working just fine). Now. I need to place after this numer: 0001 then 0002 then 0003 and so on, for each “new row” created.

I’m getting all the info from SHOPIFY (this I manage to do) so I just need to fill this column with this unique number.

I hope I was clear, since english is not my first language.

Thank you in advance!

Best answer by Troy Tessalone

You can use Storage and a Formatter step to increase the value by +1 each time.