Hello Smartsheet Community!
I am working on a project where I need to schedule staff into various sessions on different dates. I have set up a form and have collected this data. I listed each date as a question so I have 10 form fields with dates as column headers (Thursday, March 2) and staff choose either available or not available.
Now that I have this data, I realize that I am at a loss on how to figure out who is available on each date without manually sorting it. I originally did not set up my form with a form field with multiselect because I was worried about the data being jumbled but now I am wondering if I took the wrong approach. The process to figure out what sessions to assign to which available staff is becoming very manual and I'm wondering if anyone here has done a similar project and has any tips. Happy to screenshot my data if that is helpful.
Essentially, I want to assign staff to different dates based on their availability but there is a limit of the amount of staff for each date. Any ideas?