Create dynamic project plans with Sheets

Want to save a PDF version of this guide? If you're using Chrome browser, print this page and select the "Save as PDF" option. If you're using other browsers or third-party PDF tools, see their instructions on how to save webpages as PDF files.

Create dynamic project plans with Sheets

Need a quick way to divide work, assign tasks, track due dates, and receive status updates on a project? Track, update, and collaborate on project tasks with your team in a shared spreadsheet using Google Sheets.

Create dynamic project plans with Sheets

Set up your project plan

Start by creating your project plan and adding all the information you want to capture from your team.

In this section, you learn how to:


Create a project spreadsheet

  1. In Google Drive, click   New   > Google Sheets > Blank spreadsheet.
  2. Click Untitled spreadsheet and enter a new title for your project plan.
  3. Add column headings. For example, you might track the tasks for a project and include columns for task owner, due date, status, and comments.
  4. Add content to the sheet to track the project plan. After you share the sheet, other people can add content as well.

Create a project spreadsheet

Insert task descriptions

If your column heading or task needs a bit more explanation, add a descriptive note.

  1. Select the column or cells where you want to add a note.
  2. Select Insert > Notes.
  3. Type your description.
  4. Click anywhere outside the note to close it.

Insert task descriptions

Create lists in a cell

Let people choose from options in a list. For example, to track progress in a project plan, create a Status column with options such as Not started, In progress, or Complete.

Create lists in a cell:

  1. Select the column where you want to add the choices.
  2. Click Data > Data validation.
  3. Next to Criteria, select List of items.
  4. Enter the choices separated by commas.
  5. Click Save.
  6. (Optional) To see the choices, click the arrow in a cell under the column.

Limit choices

Set up progress trackers

See how your project tasks are progressing at a glance with conditional formatting rules. For example, add colors to make completed tasks stand out from tasks that haven’t been started or are in progress.

Set up progress trackers:

    1. Open Sheets and select the column that you want to apply the formatting rules to.
    2. Select Format > Conditional formatting.
    3. Set up the rules. In this example, you assign a different color to tasks that are Complete, Not started, or In progress:

a On the Single color tab, under Format cells if, select Text contains.

b In the box under Text contains, type Complete.

c Under Formatting style, click the list to choose if you want the background or text to be colored.

d To assign a custom text or background color, click Text color format_color_text or Fill color format_color_fill. If needed, you can specify a color for the text and a color for the background.

e If you want to add more rules, click Add another rule and follow the same steps. For example, assign a red background to Not started tasks and an orange background to In progress tasks.

f Click Done.

Set up progress trackers

Add notifications

Stay on top of project updates and status changes with email notifications. You’ll know when someone’s made a change to your project plan, who made the change, when they made it, and what’s changed. You can also choose how often you want to be notified.

Add notifications:

  1. In the spreadsheet, select Tools > Notification rules.
  2. Select when and how often you want to receive notifications.
  3. Click Save.
  4. Click Done.

Add notifications

Collaborate with your team


Lock critical content

Sometimes there are sections of content you don't want your team to edit. Make certain content protected so it can't be edited, or can only be edited by specific people.

Lock critical content:

  1. Select the cells you want to protect.
  2. Click Data > Protected sheets and ranges.
  3. Click Set permissions.
  4. Choose an option:
    • To restrict any changes to certain people, select Restrict who can edit this range and select who can edit the cells.
    • To display a warning to alert people before they make a change, select Show a warning when editing this range.
  5. Click Done.
Lock critical content

Create a group for your team

To send email to your team using a single email address and simplify sharing, set up a Google Groups email list.

Note: When you share with a group, all members get the same level of access.

As you add new people to your group, they automatically gain access to content you previously shared with the group. Similarly, if you remove someone from a group, that person no longer has access to any content you shared with the group.

Create an email list group:

  1. In Groups, click CREATE GROUP.
  2. Enter a group name and group email address.
  3. If you want to, add a description of the group. You can also set the group's primary language.
  4. Next to Group type, select Email list.
  5. Next to Basic Permissions, choose who can view topics, post, and join the group. For more information, see Get started with Groups.
  6. Click CREATE.
  7. Click Invite people to join the group.
  8. Enter email addresses of the people you want to invite to join the group.
  9. Click Send invites.

Create a Google Group for your team

Share the spreadsheet with your team

Next, share the project plan with your team members (or with the group you created for your team).

Share a file you own or can edit:

  1. In Sheets, open the file you want to share.
  2. Click Share.
  3. Enter individual email addresses (or just your project team’s Google Groups address).
  4. Choose what kind of access you want to grant people:
    • Can edit—Collaborators can add and edit content, or add comments. If you want your team members to update the project plan themselves, choose this option.
    • Can comment—Collaborators can add comments, but not edit content.
    • Can view—People can view the file, but not edit or add comments.
  5. (Optional) Add a note describing the project plan.
  6. Click Send.

Everyone you shared the file with will receive an email with a link to it. If you gave your team members edit access, they can:

  • Add or update content, like tasks, owners, and due dates.
  • Filter content to show what they’re interested in.
  • Insert comments addressed to specific people.
  • Update the status for tasks.
  • Add descriptive notes to tasks.

Share the spreadsheet with your team

Add checkboxes

  1. In Sheets, open a spreadsheet and select the cells where you want checkboxes.
  2. Click Insert > Checkbox.

    Note: In formulas, unselected checkboxes have a value of FALSE (exclude) and selected checkboxes have a value of TRUE (include). You can see the value in the Formula bar. You can also change this value.

  3. (Optional) To delete checkboxes, select the checkboxes you want to remove and press Delete.


Create a filter view

Want to see tasks assigned to you or due on a specific day? Create a filter view.

  1. At the top, click Data > Filter views > Create new filter view.
  2. In the top left corner, click next to Name and enter a name for the filter view.
  3. Click the arrows in the column headers and select options to sort and filter the data.
  4. (Optional) To email a link to the filter view, copy the URL and paste it in an email.
  5. At the top right, click Close close to close your filter view. Your filter view is automatically saved.

Organize information by filtering

Add comments and replies

  1. In Docs, Sheets, or Slides, select the text you'd like to comment on.
  2. Click Comment comment > Add comment add_comment.
  3. Enter your comment in the box.
  4. (Optional) To direct your task or comment to a specific person, enter a plus sign (+) followed by their email address. You can add as many people as you want. Each person will get an email with your comment and a link to the file.
  5. (Optional) To assign the comment to a specific person, check the Assign to box.
  6. Click Comment or Assign.

Add comments and targeted feedback

Do more with G Suite

G Suite is more powerful when you use the products together as a package. Here are some key ways to work faster and collaborate better on your project plan.

In this section, you learn how to:


Attach your project plan to team meetings

Make sure everyone has the latest copy of the project plan before the meeting—attach your project plan to the Google Calendar meeting invitation. Team members, both onsite and remote, can access and update it in real time. You can even spend the first few minutes of the meeting getting status updates from everyone, and updating the project plan accordingly.

Attach your project plan to a Calendar invite:

  1. In Calendar, open your event.
  2. In the Event description field, click Add attachment attach_file.
  3. Choose the project plan spreadsheet and click Select.
  4. Click Save.


Present project plans in video meetings

Present your project plan during your team meetings so everyone, including remote members, are on the same page.

Present your project plan:

  1. In Drive, open your project plan.
  2. In Hangouts Meet, click Present now and choose what to share:
    • Your entire screen
    • A window
  3. Select Share.
  4. To stop presenting, click Stop sharing, or at the bottom corner, click You Are Presenting > Cancel your presentation.
Present project plans over video calls

Embed project plans on your team site

Share a master copy of your project plan on your team website. Updates to the spreadsheet automatically appear on your website.

Embed your project plan on your team site:

  1. In Google Sites, open the page on your website where you want to embed the spreadsheet.
  2. At the top of the page, click Insert > Sheets.
  3. Choose your project plan and click Insert.
Embed project plans on your team website

Access and edit on the go

When you’re away from your desk, you can still view and edit your project plan on your phone or tablet. Just download the Sheets app. Any changes you make automatically sync to the web and to all your other devices, so you’re always up to date, everywhere.

On Android devices:

  1. Touch the Google Play icon.
  2. Find and install the Google Sheets app.

On iOS devices:

  1. Touch the App Store icon.
  2. Find and install the Google Sheets app.
Access and edit on the go

Next steps

Try it now

Make a copy of this project plan template to give Sheets a try.

Get more training

Discover more ways to collaborate better with Sheets—edit Microsoft® Excel® spreadsheets without installing Office, switch to earlier versions of your spreadsheet, access your work offline, and more.