Automatically assign people to rows based on conditions


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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!