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


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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!