Forum Discussion
Using lists to display timetables
Hi,
I’ve created a timetable to track student lessons at my school (what subject and which staff - selected from lists) I have all students tracked on the same table, and a sheet for each day of the week (eg Mon - Fri)
what I’d really like to add now is a sheet where I can select a students name from a list, and generate a full week timetable just for that student. I’ve tried to work out how to do that, but I’m struggling!
if possible I’d then like to do the same for staff members to show which lessons and students they’re supporting - but think that may be more difficult!
Happy to attach where I’m up to if it helps!
- mathetesSilver Contributor
Happy to attach where I’m up to if it helps!
It always helps. Otherwise we're forced to resort to imagining your layout, which isn't a good way to come up with specific suggestions.
If you are able, the best way to do this is to drag and drop a copy of the file (no real names of students or teachers, please; use Disney characters or names from classic literature) to the bottom of the area where you reply to this message. If that doesn't work use OneDrive or GoogleDrive and paste a link here that grants access.