Hello, I’m looking to use autonumbering, but add the last 2 digits of the year based on date created.
I’m currently using this to manually add “20-” to the beginning of each number. I’d like to automate it so it grabs the date created info.
That depends. Your original message doesn’t indicate where that two-digit year indicator belongs related to the other pieces.
I notice that you’re using both types of concatenation in your formula: the CONCATENATE() function, and the & operator. My preference is to only use the latter, primarily because it’s shorter. For example:
thing1 & thing2 & thing3
…will always be shorter than:
CONCATENATE(thing1, thing2, thing3)
The savings becomes even more apparent when you’re concatenating items inside a function, the output of which is concatenated to something else, etc. Frankly, I don’t know why the CONCATENATE() function exists. Its output is identical to that of the & operator, and the operator is so much shorter.
Anyway, taking your original example above and rewriting it to only use the & operator, it would look like this: