Autonumbering of Multiple Categories

Hi,

I am building a centralised event capturing (by form) register which may contain 5 - 6 different types of events (incidents, actions, improvements etc.).

I want to have a number automatically assigned that is sequential, based on the previous number of the same category. Example below.

I have played around with a few options but cannot get it to work.

New entries can be added to the top or bottom of the sheet, although top is preferred but not essential (since the output will be reviewed by reports most likely).

Find more posts tagged with

Accepted answers

Paul Newcome

Insert an auto-number column (called "Auto" in this example) with no special formatting and then use the below column formula:

=UPPER(LEFT([Type of thing]@row, 3)) + "-" + COUNTIFS([Type of thing]:[Type of thing], @cell = [Type of thing]@row, Auto:Auto, @cell<= Auto@row)

All comments

Paul Newcome

Insert an auto-number column (called "Auto" in this example) with no special formatting and then use the below column formula:

=UPPER(LEFT([Type of thing]@row, 3)) + "-" + COUNTIFS([Type of thing]:[Type of thing], @cell = [Type of thing]@row, Auto:Auto, @cell<= Auto@row)

Neil Watson

Thanks @Paul Newcome. Worked straight out of the box. Much appreciated.

Paul Newcome

Happy to help. 👍️

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.