max value by category

edited 12/09/19 in Formulas and Functions

Hi I'm stuck on figuring this one out. I am trying to generate a sequential number("Sequence" column) by category ("Application"). I want the formula to calculate the max value of all the records in sequence where application = application in the new record (user would have selected this from a drop-down.

this is what I am currently trying but I am getting an incorrect arguments error.

MAX(COLLECT(Sequence1:Sequence21, Application1:Application22, Application@row = Application1)

Ideally, I would like to use the autonumber feature in SS but I couldn't see how to manage sequences by category but in a single column.

Any help you can offer is greatly appreciated!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!