Date Wise Serial No

[eoshila]

I want to generate serial numbers by today’s date with more 3 digits that will be add automatically with the current date.

Like
260821-001
260821-002

Please help me by easy way.

[Marc_Dillon]

I would point you to the same resources that I posted in your earlier similar thread:

Custom Serial Number Create Questions

I am trying to make an app for myself. 1st Question here is a column for serial numbers. I used the formula “count(select(sales[Sales No],True))” for adding new serial. But when two-person go to add a new entry at the same time, The serial comes the same and makes it duplicate. How to defend it. 2nd Questions I want to create the serial by first two letters from username or usermail & last 3 digits from the count result of today new added. Like User name -1-- eoshila@abc.com User name -2-…

As well as:

help.appsheet.com

CONCATENATE()

Merged text from parts

And TEXT() to format the date how you want it:

help.appsheet.com

TEXT()

Format as text