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

ady

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.

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.