Here’s A Colorful Class Schedule Template using Google Sheets
Just set the class names, the instructor names, and the times, and you’re good to go!
1 min readOct 7, 2020
How do I add colors to my instructors’ names?
Click on the sheet labeled “Staff” (in the bottom left-hand corner) and set it to the names of your staff members. Currently, it only supports up to 15 instructors, but you can add more colors by adding a rule in Format > Conditional Format Rules
Can I change the start date?
Sure! Just set the start date in cell A1, and the week will automatically update itself.
What happens if I need to add/delete class times?
No problem! Just add and delete rows as needed, the color formatting will remain the same.
What if I have more than one week?
Just copy and paste the week and update the start date!
Originally published at https://www.takeinitiative.io on October 7, 2020.
