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.
Answers
-
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)
-
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?
-
Yes. The formula would go into a separate column.
Help Article Resources
Categories
Check out the Formula Handbook template!