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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!