App Icon
Connor Burke
•  33,880
Overview
Use a spreadsheet to manage your institutional schedule, and let Shift Scheduler automatically manage each user's Google Calendar!
Automatically create and maintain your organization's schedule in a single spreadsheet that automatically creates Google Calendar events for your users, as well as creates and maintains separate a separate spreadsheet view reorganizing your schedule by shift, to immediately see who's covering what responsibilities.

Designed by a family medicine Chief Resident with medical residencies in mind (but flexible enough to be used by anyone with complex scheduling needs), this shift scheduling application simplifies the process of creating and maintaining complex schedules for even large numbers of people. At the first run, an example spreadsheet is created to demonstrate how the program works. A tutorial guides you through customizing that spreadsheet to your specific users, and the program will open a sidebar in which you'll have the option of defining several attributes of commonly worked shifts (each can have a start and end time, custom location, as well as several other advanced properties). With that, setup is complete and you're ready to schedule!

Then, when you then assign shifts to your users (either by assigning a shift to their name in the "User View" tab or by assigning their name to a shift in the "Shift View" tab), the program will use the shift information you've already supplied it to create google calendar events for your users (and synchronize with the other spreadsheet view to keep everything up to date)! 

If you assign a user a shift name which doesn't match one of the specially defined shifts you've set up in the sidebar, the program will create an All Day event in the google calendar for your user instead. You can even type in a custom event with it's own times -- for example "1-4:30 Meeting" -- and it will create a calendar event based on those times. You can create multiple events in the same day by separating them with a forward slash "/" or a comma ",". 

There are lots of advanced options and features too, but if you're not interested by now I don't think they'll convince you. Check it out for yourself! You can always access a more detailed summary of information within the program by opening the help or tutorial views from the menu.

My residency program is now using this as its primary scheduling resource - I hope you find some use for it as well!
Reviews
Language:
Sort by:
Profile Picture
NESO Library
November 5, 2020
Is there an option NOT to create a google calendar for the employees every time you open the shift scheduler?
Is this review helpful?
Yes
No
Profile Pciture
Andrew Thome
November 17, 2020
Would love to see this option. It caused an error on my form and now I've exceeded the calendar creation limit - it won't work now.
Profile Picture
Elaine Miller
October 31, 2020
I can't find the options to update the color scheme of the conditional formatting. Is this possible?
Is this review helpful?
Yes
No
Profile Picture
Seren Peters
October 30, 2020
This add-on is amazing. Tutorial is very helpful. Wish there weren't so many error messages but they don't actually stop you from doing what you need to.
Is this review helpful?
Yes
No
Profile Picture
Belinda Nyamgero
September 3, 2020
Is there a way someone can bulk upload users especially if you are working with more than 100 users. That is the only downside for me when creating the schedule
Is this review helpful?
Yes
No
Profile Picture
Suzanne Dunsterville
August 27, 2020
Is there a way I can have in User View the Users going down the side and the dates across the top?
Is this review helpful?
Yes
No
Profile Picture
John Pinares
August 27, 2020
Something useful would be a better way to set up recurring events (i.e., days off, meetings, etc.) Or if there was a way to sync the created calendar with the spreadsheet since I can easily create a recurring event on calendar.
Is this review helpful?
Yes
No
Profile Picture
Bhairagini Maa Srirekha
August 25, 2020
Hello, how can i create multiple tabs for different time frames? I wld like a separate tab for each month. Is it possible?
Is this review helpful?
Yes
No
Profile Picture
Tom Erlandsen
July 23, 2020
Terrible app. Not at all user friendly, and through multiple errors it ended up deleting roughly an hour of work. Total waste
Is this review helpful?
Yes
No
Profile Picture
Ignasi Ticó
July 22, 2020
Love the add-on, thank you! Is there a way that the event which is created in google calendar receives the same name as the user? We are not using the shift setup, only the direct schedule (10-18) and the event has no title. Thank you again!
Is this review helpful?
Yes
No
Profile Picture
Woody
July 17, 2020
This is an awesome template that has made it MUCH easier to schedule and coordinate our ambulance service’s wild schedules and staffing. Only problem is I get a lot of issue out of Shift View not updating properly to match User View...anyone got a fix? Resynchronize Everything doesn’t seem to force it to fix. Help!!
Is this review helpful?
Yes
No
1-10 of 40
Additional information
Connor Burke
Terms of Service
Search
Clear search
Close search
Google apps
Main menu