I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific locations (we do not know these specific locations until last minute). I have built a survey using Smartsheet forms to get the availability of these volunteers and their geographical preferences to minimize travel to these locations.
Is there a way to automate their volunteer assignment on smartsheet (i.e. calculate/map out the most equitable volunteer assignments based on the volunteers' availability and geographical preference)?
An ideal output would be a table that has assigned volunteers to a specific location and shift.
Please let me know if you have any ideas or if anyone has leveraged Smartsheet to do anything similar.