I'm trying to create a "ticketing" solution in SharePoint Online using a custom list. Right now I have a ID field which will keep track of the ticket number, and I also have a 'queue' field, which will indicate what number it rests in the queue. In addition to that, I have a 'status' field that indicates what stage the ticket is in.
Is there a way to have the queue field automatically increment from 1 from the lowest number of active tickets? My thought is once a ticket is closed, the queue value could be nullified. Then the system will +1 to the next largest number, e.g. if there are no tickets then it'll be assigned a queue value of 1. If there are 5 tickets existing it'll assign the next submitted ticket with a value of 6, etc.