Auto Assign Rotation
I am part of an application team. At any point, any one of us can take and work on any application request.
Requests are submitted via a form on our Application tracker sheet. I am looking to auto-assign someone to the next application entered either by who has the fewest open tasks or simply by rotating through the list. Right now there is only 2 of us actively taking on new applications.
I have attached a basic screenshot of what we're working with.
This sheet is driven by a form to auto populate at the bottom of the list with "Open" in the Status Column. The "ID" is auto populated by adding a number to the previous. This is done on a separate helper sheet.
Current Workflows are set to automatically move "Completed" tasks to a separate sheet.
Is there a way to do this without a helper sheet? Can I utilize helper columns in the same sheet and just hide them?
Help Article Resources
Check out the Formula Handbook template!