Auto numbering with 3 letter pre-fix

Hi All

I am using the below formula to generate a unique ID based on the first letter of the selected type. This works well if all types start with a different letter, however i have 3 types that start with P

=IF([Row ID]@row = "", "", LEFT(Type@row , 1) + "-" + [Row ID]@row )

Could you please show me a formula that will pre-fix the first 3 letters of a type so i can differentiate between them?

Cheers

Paul

Find more posts tagged with

Accepted answers

All comments

Ray Lindstrom

Hi @Paul69g,

Try replacing your LEFT function with MID. Something like this

=MID([Type]@row , 1, 3)

=IF([Row ID]@row = "", "", MID([Type]@row , 1, 3) + "-" + [Row ID]@row )

BRgds,
-Ray

Ray Lindstrom

The square brackets around Type are optional since there are no spaces or special characters in the column name.

So, it could also look like this:

=IF([Row ID]@row = "", "", MID(Type@row , 1, 3) + "-" + [Row ID]@row )

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.