Creating Unique IDs

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.

Find more posts tagged with

Accepted answers

All comments

EvanShortreed

Good Afternoon,

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

Set up your auto-number with the markings of UMMS_XXXX
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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.