Trying to set up a swifter way to patching up bookings of crew rather than copy pasting manually.
Hoping to be able to by simply filling in an "availability calendar", it could auto suggest in dropdown-menus who are available at any given shift I am planning.
Adding in a mockup of the case in .xls here.
I am hoping there is a way to code data validation list source to reflect the date on the bookings row, with the verified persons ("yes") next to the matching date in the calendar.
If that is too much segments in one single formula, I have also attempted to set it up with a suggestion in the "setup"-tab, where I have at least isolated the names onto a vertical list aligned on the matching date row. Now, I am amble to simply add manually that row as a dropdown-menu, as exemplified in B16:B19 on the "Booking" tab.
However, I would obviously love for this to be automated, given that the information is already available.
Is that doable?
That alone would be great, and if that works, are these two potential upgrades within reach as well?
1) Getting the dropdown to exclude suggestions if the name has already been used in a different event on the same date. (Row 18/19 vs Row 22/23).
2) Getting the dropdown to only suggest names that also holds the matching roles needed in the event (b1:f1).
Hoping to get some new insights into this. I have tried to look up a lot of "advanced drop-down"-tutorials, but nothing matching my needs specifically.
Love to learn!
Bookmarks