max value by category

dvrgrl

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!

Thanks!

Paul Newcome

Can you provide some screenshots and more details? Is the MAX/COLLECT part of a larger formula?