Schedule Tool
A Google-Sheets-based scheduling tool designed to help managers and teams organize, track and update employee work schedules. While more robust tools might use a database, I was required to work within the Google Sheets ecosystem. I developed a custom string format to store and retrieve schedule data cleanly—no add-ons or external services required.
- Interactive calendar interface for shift assignments.
- Custom sidebar UI
- Data validation & conflict detection
- Manager schedule confirmation
- Filtering and summation by schedule marker type
- String-based data encoding that translates into a readable, color-coded calendar view
- Simple, no-database-needed solution ideal for small teams or startups using Google Workspace