Invoice Sequencial Numbers

Hi, i wonder if you can help me on how can i get an automatic and sequencial code for my invoices number...
I need it to be like this: 0001-00000001 / 0001-00000002 and so on and so on...
I tried Concatenate, but the thing is i cannot figure out how to stablish the lenght of the number cannot exceed the 8 digits after the "0001-"
Thanks!




Solved Solved
0 2 282
1 ACCEPTED SOLUTION

CONCATENATE(
  "0001-",
  RIGHT(
    CONCATENATE(
      "0000000",
      InsertFancyExpressionForSequential
    ),
    8
  )
)

View solution in original post

2 REPLIES 2

CONCATENATE(
  "0001-",
  RIGHT(
    CONCATENATE(
      "0000000",
      InsertFancyExpressionForSequential
    ),
    8
  )
)

Thank youuu!

Top Labels in this Space