Date Wise Serial No

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.

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

[Custom Serial Number Create](https://community.appsheet.com/t/custom-serial-number-create/53674) 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:

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

1 Like