Creating Unique IDs

mo_man00

I am trying to create Custom IDs for the rows that do not have IDs. I have the following columns, RICE ID (this is where the IDs should generate) a business unit column (it includes HR, SCM, FIN) The format should be UMMS_**Whatever Business Unit is in that section**_Incremental number. so a few examples would be.

UMMS_HR_0001

UMMS_FIN_0002

UMMS_SCM-0003

I've tried solutions with an #auto-id column and helper column but not sure what I was doing wrong so anything help is appreciated.

EvanShortreed

Good Afternoon,

You were on the right track with the helper column! Here are the steps:

1. Set up your auto-number with the markings of UMMS_XXXX
2. In the helper column write a formula to bring together the auto number and department.

Happy to hop on a call to review with you if you need additional help.

mo_man00

Can you give me the formula with the information I've provided.