Google user
Original Poster
Feb 9, 2023
Scheduling people and organising per day
I've been trying to make a formula that pulls information out of a schedule, to use the information to send out a daily work schedule to staff.
Here's a link to the sheet with an 'Example answer' tab of how I'm trying to get the information on the 'Schedule' tab organised. I have included previous tabs for reference:
I managed to make a version myself, but it used loads of different steps and didn't always seem to work, so any help would be very much appreciated!
All the best, George
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
Feb 9, 2023
The re-formatting i'm suggesting is to include the date to the right of every entry in each date table. i did this in white text in white background so you can't see them in the EM Schedule tab.
EM Schedule and EM Example show what i mean. This works, but i dont see how this scales very nicely - what does your full calendar look like?
Eric
Original Poster Google user marked this as an answer
All Replies
The re-formatting i'm suggesting is to include the date to the right of every entry in each date table. i did this in white text in white background so you can't see them in the EM Schedule tab.
EM Schedule and EM Example show what i mean. This works, but i dont see how this scales very nicely - what does your full calendar look like?
Eric
Original Poster Google user marked this as an answer
Google user
Original Poster
Feb 17, 2023
Apologies for the slow reply. This is very useful, thanks.
The only issue it seems to have is when there's two names in the box, separated by a comma. I tried to create something using SPLIT, but the filter function seems to only work with one column at a time.
Do you have any ideas?
Many thanks, George