I am trying to book an Orchestra using Smartsheet Forms and Sheets, any ideas?
The form needs to go out to the pool of musicians and poll their availability. Then the availability needs to be able to be quarriable to book musicians by part.
For example, I need the following parts covered each day:
Flue, Trumpet, Trombone, Tuba
I need a form that can go out to all the flute platers and they select the dates they are available. I then book them into the sheet.
Another need is that I will have to print a roster each day including their employee number, name, and part.
So I think this is some combination of a form to get the data, a grid to book them into the dates, and a report for the day's roster.
There are 51 musicians each day, and 6 weeks of performances 7 days a week.