Costum ID

[Konstruction]

Hi there. I'm trying to make a custom auto number. The constant is kasse 00 and then want the autonember to be kasse 001, kasse 002, kasse 003 and so on. Can anybody send me in the right direction?

And off cause will there be a problem when I reach kasse 010. It needs to be kasse 010 and not kasse 0010

best regards 

Thomas

[TheTimeSavingCo · Accepted solution]

Try out this formula:

SWITCH(
  LEN(CONCATENATE(ID)),
  1, "kasse 00" & ID,
  2, "kasse 0" & ID,
  3, "kasse " & ID,
  'Default'
)

Which should give you this:

Here's a link to a base where this is set up that you can duplicate and play with

[Konstruction]

It works... Thanks a lot. Btw. Is it possible to switch the 2 column. I need the kasse 001 numbers as but not the ID and when ID is in the first row I can't hide it

Regards Thomas

[TheTimeSavingCo]

Hm, I don't fully understand what you're asking,  sorry.  If it helps, the column order doesn't matter; as long as the formula's pointed at the right field name it'll work