Creating custom UNIQUEID()

we have our invoices in a google sheets table and right now our ID/key is in this form:

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!


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.

1 Like
1 Like

Thank you both for your fast response!

1 Like