Is there a way to automate the next ticket number in a sheet

Hi,

I have a sheet that tracks escalations, uplift in sales and training and I put a number to them. EG ET1 for escalations, UP1 for uplift and TR for training. Each time a add a new line I just change it to the next number in the specific track of escalations, uplift and training.

Is there a way of automating this?

I use drop downs in a column for escalations, uplift, training.

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

You would insert an auto-number column (no special formatting) then use a formula such as this:

=UPPER(LEFT([Track Column Name]@row, 2)) + COUNTIFS([Auto-Number]:[Auto-Number], @cell<= [Auto-Number]@row, [Track Column Name]:[Track Column Name], @cell = [Track Column Name]@row)

ady

thanks, I have added a column for Auto Number but it doesn't allow me to do any formula in that column. Do i do the formula somewhere else?

Paul Newcome

Yes. The formula would go into a separate column.

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.