I have a pre-existing order number in the format of “LS003456” that I would like to auto-generate. I’m using a second field with autonumber and then a formula like this:
which gives a result of:
Is it possible to modify the formula so that there are always 6 digits after the “LS” and any leading zeros are maintained?
My end goal is to have a sequence like: