Automatically assign people to rows based on conditions

Mike Willacy

Hello, hopefully someone can help me. I'm setting up a learning support Smartsheet where support workers are assigned to students. I would love this process to be randomly automated when a new row is added to the Smartsheet, however with conditions. The conditions would be having a capped amount of students depending on how many hours a week they work, e.g 100 students per 37 hours - is this do-able?

Any help appreciated!

Hollie Green

This post might help you develop your solution

https://community.smartsheet.com/discussion/84031/ideas-on-randomizing-assignments