How to Make a Schedule on Google Sheets ClickUp Blog

How to Make a Schedule on Google Sheets (With Templates)

Chances are you’ve been using Google Workspace for years. But did you know you can easily templatize and make a schedule in Google Sheets

Some of us were surprised to learn about how you can create a schedule such as:

  • A daily schedule template for your ideal morning and evening routines
  • An employee schedule template for your team’s 4-day workweek
  • A school and practice schedule for your child’s soccer season

Sounds pretty helpful, right? 

In this article, we’ll show you the simple steps to build a daily schedule, save it as a template, and create rules to automatically highlight certain tasks and events. 

Let’s get started! 🏁

How to make a daily schedule in Google Sheets

1. Open a weekly schedule template from the Google Sheets template gallery by selecting New > Google Sheets > From a template

open a weekly schedule template or project schedule template from google drive using a google chrome browser window
Created in Google Sheets

2. Choose the Schedule template

select the google spreadsheet schedule template from the Google template gallery
Created in Google Sheets

3. Double click cell C2 and change to your intended start date. Although the Google sheets schedule template has a Monday start date, you can choose any day of the week!

change the starting date on the sheets weekly schedule template
Created in Google Sheets

4. This next step is optional. Highlight the top and bottom cells to change the template’s background color. Then, perform the same treatment to the text (Notes, To Do) cells

select rows 1 and 2 in the weekly schedule template and change the color
Created in Google Sheets

5. Add your schedule items

create a weekly calendar schedule template for repeated use
Created in Google Sheets

6. Create conditional formatting rules to color–code appointments, events, meetings, and reminders by clicking the Select All button below the formula bar

click on select all icon in the schedule template to highlight all cells
Created in Google Sheets

7. Right-click anywhere on the sheet > View more cell actions > Conditional formatting

use google sheets conditional formatting to create color categories in the schedule template
Created in Google Sheets

If you’re struggling to create color categories, take a quick pause here! Don’t stress too much about making your schedule look Pinterest-worthy. The key is to make it practical. 

In the example below, I’ve created five rules with three color categories (meetings, personal, and focus sessions): 

  • If the text contains “mtg”, highlight the cell green
  • If the text contains “deep work”, highlight the cell blue
  • If the text contains “lunch”, highlight the cell purple
  • If the text contains “appt”, highlight the cell purple
  • If the text contains “walk the doggo”, highlight the cell purple
automatically update events, appointments, and meetings with conditional formatting in google schedule template
Created in Google Sheets

Now it’s your turn!

8. Open the drop-down menu under Format Rules to apply any rule. Then, adjust the style you want under Formatting style

customize the schedule template with assigned color categories
Created in Google Sheets

9. Save as a new template by adding Template to the Sheet’s title

title the sheets page schedule template for future use
Created in Google Sheets

10. Click the folder icon next to the Sheet’s title > New Folder icon

create a template folder in google drive to save your weekly schedule template
Created in Google Sheets

11. Name the folder and click the Checkmark icon to save

save your schedule template in the new template folder
Created in Google Sheets

12. Click Move Here to save the schedule template into the folder you created

click move here to move the schedule template into the new google drive template folder
Created in Google Sheets

Success! A new daily schedule you can reuse and tweak to your heart’s content. 

We have more Google Workspace resources and recommendations if you’re looking for other alternatives to improve your planning needs! ⬇️ 

More Google Sheets and Docs tutorials

How to Make a Calendar in Google Sheets
How to Make a Gantt Chart in Google Sheets
How to Make a Google Sheets Dashboard 
How to Make a Calendar in Google Docs
How to Make a Timeline in Google Docs
How to Create a Gantt Chart in Google Docs

Google Sheets schedule templates

• Schedule via Google Sheets
• Daily Schedule via template.net
• Work From Home Daily Schedule via template.net

Google Sheets vs. modern calendar software 

I get it, life happens: your laptop dies. Riley texts you their soccer coach is changing practice dates from Tuesdays to Thursdays. The project that’s weeks away from closing gets delayed. 

I don’t know about you, but the thought of editing spreadsheet rows and columns already gives me a tech headache. What should take less than a minute to update somehow takes as long as an episode of The Great British Bake Off

Compared to modern calendar software that can transform a static schedule into a real-time resource, Google Sheets has three glaring disadvantages: 

  1. No task management features to communicate or collaborate with people
  2. No native integration with project management systems
  3. No potential to scale

If you’re thinking, “But Google Sheets is free and I don’t have the time to learn new software!” I definitely understand. All things considered, how would you feel if a modern calendar software could do this for you:

  • Reporting features for better project planning in the future? Prepared
  • Task estimates to plan ahead for unforeseen hurdles? Activated
  • Multiple calendars on one screen? Done.

In hindsight, modern calendar software is a time-saving necessity. And you have free options! The best free software? I’m so glad you asked. 

ClickUp: a free remedy for Google Sheets headaches

ClickUp is the ultimate productivity platform allowing teams to manage projects, collaborate smarter, and bring all work under one tool. Whether you’re new to productivity apps or are a seasoned schedule planner, ClickUp’s customization can help you shape your best days! ✨

manage work and launch meetings directly from your clickup calendar view
Bring docs, spreadsheets, real-time chat, and more into one fully customizable ClickUp Workspace

A modern calendar software like ClickUp offers more than creating a daily schedule template:    

What’s something you wanted to accomplish at work or home if you had extra hours in your week? With ClickUp’s Calendar view, anything is possible! 🔮

Questions? Comments? We're here for you 24/7 at help@clickup.com!

Sign up for FREE
and start using ClickUp in seconds!
Please enter valid email address