I want to make a unique lot number.
but i use column The model is made into lot numbers.
My model will have many characters, for example:
9109ss
9129ss
5800
5400
…
Want to make lot numbers as follows:
When the model is selected as 9109ss
The lot number must be issued as follows. 9109ss2021100001
will be model name, year, month, run code with 4 digits
But the formula I can use is only the column name or the given name. I want the letters in front of it to change according to the model.
Is the model name contained in the row anywhere?
สตีฟสตีฟ คอยล์
9109ss model name
2021 year number
11 month number
0001 serial number
want to run like this 9109SS2021110001
There are 2 formulas that I have tried.
Formula 1, the result is YE52021111.
Formula 2, the result is YE00000.
Formula 1 works, but the person who let me make an app, wants the number 0 mainly after the month number, which formula 1 results in the year 2021, month 11, running number 1, but he wants the sequence run number to be up to thousands, such as 0001 like this. Yes
I would guess [ID] is either blank or is not a Date or DateTime value.
