Assign Projects in a Rotation Based on Category

I need to be able to automatically assign projects to two individuals (1:1 ratio) based on a specific category of contracts. For example, if a lease comes in that needs to be reviewed, it would be assigned to one person and the next lease would get assigned to the second person. I have a list of about 8 different categories and I need them to rotate back and forth between every category (not just rotating back and forth between every assignment regardless of category).
Answers
-
hello @Stefanie King,
I would use the workflow Assign To: to setup automatically to whom it is assigned based on the conditions.
You can find this workfow in automations.
Experienced IT PM and the Real Smartsheet Enthusiast.
Is there anything else we can help you with? - book your time.
MASA Consult - Your Aligned Smartsheet Gold Partner
Find us on LinkedIn & Check our Smartsheet Solutions!
Tag my name: @kowal if you want me to respond :)
-
I don't see how to use that workflow to associate a rotation based on category. I see that you can set it to select someone if they pick a specific type/category but I need it to rotate between two people for every type of category
Help Article Resources
Categories
Check out the Formula Handbook template!