Hi everyone,
I need help preparing a spreadsheet for our school team of 8 coworkers. I want to create a sheet that displays everyone's timetables side by side for a given day. This will make it easier to find coverage when someone is sick. Currently, my supervisor has to look at 9 different papers, which is challenging, especially since we find out about absences between 6-7 am and need to arrange cover by 8 am.
My supervisor uses a Google Doc for each coworker’s schedule, with some cells merged. We’d like to keep this format to minimize changes. I’ve copied each schedule into one sheet (one per coworker). If the timetable changes, we can easily copy and paste the updates from the Google Doc.
The idea is to use the main sheet to display schedules for a selected day by choosing from a dropdown in cell A1 (merged for better visibility).I've figured out how to display the information for a given coworker and a given date (Main, Lika, Monday ). I created the buttons using the dropdown feature in google sheets, then used the formula "=IF". I'm still struggling when I try to display more than one day (as in D2). One of the coworkers (Sal) only works in the mornings.
It would also be possible just to show individual buttons for each day like in a7 to a11 (I like the buttons figure but I don't know how to create it without a dropdown menu). Then, if we "push" a button the table in the "Main" sheet would display each column from a different sheet in the corresponding one for each coworker.
Do you think this is possible? Do I need to change the way the sheet is built now? An alternative structure would be to have a different tab for each day but it would be visually heavier I find.
Thanks a lot!
docs.google.com
I need help preparing a spreadsheet for our school team of 8 coworkers. I want to create a sheet that displays everyone's timetables side by side for a given day. This will make it easier to find coverage when someone is sick. Currently, my supervisor has to look at 9 different papers, which is challenging, especially since we find out about absences between 6-7 am and need to arrange cover by 8 am.
My supervisor uses a Google Doc for each coworker’s schedule, with some cells merged. We’d like to keep this format to minimize changes. I’ve copied each schedule into one sheet (one per coworker). If the timetable changes, we can easily copy and paste the updates from the Google Doc.
The idea is to use the main sheet to display schedules for a selected day by choosing from a dropdown in cell A1 (merged for better visibility).I've figured out how to display the information for a given coworker and a given date (Main, Lika, Monday ). I created the buttons using the dropdown feature in google sheets, then used the formula "=IF". I'm still struggling when I try to display more than one day (as in D2). One of the coworkers (Sal) only works in the mornings.
It would also be possible just to show individual buttons for each day like in a7 to a11 (I like the buttons figure but I don't know how to create it without a dropdown menu). Then, if we "push" a button the table in the "Main" sheet would display each column from a different sheet in the corresponding one for each coworker.
Do you think this is possible? Do I need to change the way the sheet is built now? An alternative structure would be to have a different tab for each day but it would be visually heavier I find.
Thanks a lot!
