Hello everyone,
I am in the process of creating a rotation schedule for work and I would like to create a drop down box that will hide a used item, in this case staff member, while also having the ability to select multiple staff members.
1. On the spreadsheet I have highlighted two rows, "CC," and "PRF." Whichever staff member is selected for "CC" or "PRF" I would like their name NOT to show up on all of the other drop down boxes for that same day. Basically, if a staff member has to complete "CC" or "PRF" then they are not allowed to complete another task that same day.
2. My second question would be whether or not you could add two staff members to one cell?
Thanks for taking the time to check out my question!
Bookmarks