How to Assign Contacts in Rotation?

emily.dobbs

Hi!

I'm currently creating a ticketing system where different types of tickets will be assigned to different technicians. I have automations set up for most of the ticketing types, but two types (Radios and Support Request) need to be rotated between two technicians.

How can I accomplish this?

SSFeatures

Hi,

You can create a Row Number column that is an auto number, so that each row has a unique number. Then you can create a Technician Number column that uses the Row Number to generate a 0 or a 1. If the number is 0, assign it to technician 1, if the number is 1 then assign the row to technician 2.

This is the Technician Number formula:

=MOD([Row Number]@row, 2)

This is what the sheet looks like:

This is what the automation looks like:

Will this solve the problem?

emily.dobbs

This will not solve my problem. I am currently using the auto numbering for the Ticket ID. Also, There are other technicians for different Ticket Categories. Only the Radios and Support Requests will rotate between two technicians. Each other Ticket Category will have a dedicated technician.

Do you have any other ideas for solutions?