sequence unique id

[MohamedSalem999]

Hello,
I have column [Store Number] which include unique id Start with (BM) and sequence number

Ex : BM307 , BM308 , BM 309 .

what the formula can use it to make it automatically and show it for user when start add new item? 

[Trevwiller · Accepted solution]

The initial value will be:
"BM" & (COUNT(UNIQUE(Table Name[Store Number])) + 1)

Make sure to have [Store Number] allow no edits in the form view.

Also please read below.

[MohamedSalem999]

thank you it is working but i just have issue,

i have question if i deleted row from google sheet he doesn't see last row he just count rows For more clarification
the last row It contains 

and the total items is 

and this from app:

so how can i solve this ?

[Aurelien]

This is exactly what is mentionned in the post about serial numbering 🙂

You may want to use this instead:

"BM" & (MAX(Table Name[Store Number]) + 1)

[MohamedSalem999]

@Aurelien okay i understand thank you

[Aurelien]

in addition:

Serial Numbers, If You Must - Google Cloud Community