Creating custom UNIQUEID()

Francis_Rafal · 11-04-2019 08:01 AM

Hi,
we have our invoices in a google sheets table and right now our ID/key is in this form:
IN0001
IN0002
…

Is it possible to set the next invoice ID (i.e. if IN0100 was the last record, let the new record be IN0101) as initial value for the key?

Thank you already for your help!

Francis

Aleksi

In generally that’s possible like “IN”&NUMBER(RIGHT([Column],4))+1) but please remember that if two or more users are using the app at the same time, you will have duplicate Key values.

Steve

Francis_Rafal

Thank you both for your fast response!