Autonumbering of Multiple Categories

Neil Watson
Neil Watson ✭✭✭✭✭✭
edited 03/21/23 in Formulas and Functions


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).

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!