Random Task Assignment

zainab22

Hello!

I am trying to figure out the best approach to automating random task assignment. I have a parent sheet where I automated rows to be copied over to the child sheet once certain criteria has been checked off. So once the rows have been copied over i am trying to automate that 2 out of 3 people will be randomly assigned to the task and if possible one person should only be assigned to a task twice back to back at a time.

SoS | Dan Palenchar

Hello @zainab22,

There is not a built in way to generate random numbers, you would need to create some type of way to do this or use the API perhaps.

However, why not track the number of assignments per user and simply assign the user with the fewest assignments? Would that work?

zainab22

Hi! Thank you for your response!

We dont have any other assignments being tracked in Smartsheet as of now.

But if we did, how would we go about it?

Also how do we go about accessing the API and do you have any other suggestions/round about ways to accomplish this