max value by category
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!
Comments
-
Can you provide some screenshots and more details? Is the MAX/COLLECT part of a larger formula?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!