Can you assign a random value based on a list?
I am trying to automate the task of assigning a person to an assignment.
Users can submit a form, which generates a row on my sheet. The row then has to be manually assigned to someone to complete it. There are no values that can be used to really assign it to one given person- these are submission for setting up new items.
Is there a way to create a list of potential assignees and randomly assign it to one of them when a new submission comes in?
Help Article Resources
Check out the Formula Handbook template!