Notification

Bring your best ideas to life with Gemini for Google Workspace. Get tips & real-life use cases for using gen AI at work.

Create project plans with Sheets

Set up your project plan

On this page


               

Want advanced Google Workspace features for your business?

Try Google Workspace today!

 

 

Create a project plan in Sheets

  1. In Google Drive, click Newand thenGoogle Sheetsand thenBlank spreadsheet.
  2. Click Untitled spreadsheet and enter a title for your project plan.
  3. Add columns. For example, you might add columns for tasks, task owners, due dates, status, and comments.
  4. Add content to track the tasks in your project.

Add descriptions to columns 

If your column heading needs a bit of explanation, you can add a descriptive note.

  1. In your spreadsheet, select the column or cells where you want to add a note.
  2. Select Insertand thenNote.
  3. Enter your description.
  4. Click anywhere outside the note to close it.

Add options or checkboxes

You can specify options for the cells in a column. For example, a task status column might have the options Not started, In progress, or Complete. You can assign a color to each option so you can see overall progress at a glance. Or, you can use checkboxes to show that a task is complete.

Add a list of options

  1. In Google Sheets, highlight the cell or range of cells where you want to add a list of options.
  2. Click Dataand thenData validation.
  3. Click Add rule.
  4. Under Criteria, select Dropdown.
  5. Enter your options. 
  6. (Optional) To assign color, at left, choose a color for each option.
  7. (Optional) To add more options, click Add another item.
  8. Click Done.

Learn more at the Google Docs Editors Help Center

Add checkboxes

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Select the cells you want to have checkboxes.
  3. In the menu at the top, click Insert and then Checkbox.
  4. To remove checkboxes, select the checkboxes you want to remove and press Delete.

Focus on tasks using filters

You can create filters so people can focus on the tasks assigned to them. For example, you might create a filter to show only the tasks for your sales team. The sales team can turn the filter on or off to see only their tasks or see all tasks in the project spreadsheet.

Important: When you add a filter, anyone with access to your spreadsheet will find the filter too. Anyone with permission to edit your spreadsheet will be able to change the filter.

  1. On your computer, open a spreadsheet in Google Sheets.
  2. To create a filter, select an option:
    • Select a range of cells, then click Data and then Create a filter
    • Right click on a cell or a range of cells, then click Create a filter.
  3. To find the filter options, go to the top of the range and click Filter Filter list.
    • Filter by condition: Choose conditions or write your own custom formulas.
      Custom formula examples
      Find unique values within a data range
      • Select Custom formula is
      • Type =COUNTIF(data_range, data_range)=1
      Find text matching “Good” or “Great” within a data range
      • Select Custom formula is
      • Type =OR(REGEXMATCH(data_range, "Good"), REGEXMATCH(data_range, "Great"))
    • Filter by values: To hide data points, uncheck the box next to the data point and click OK.
      • To create a filter and filter by cell value, right click on a cell then click Filter by cell value.
    • Search: Search for data points by typing in the search box.
    • Filter by color: Choose which text or fill color to filter by. You can filter by conditional formatting colors, but not alternating colors.
  4. To remove the filter, select an option:
    • Click Data and then Remove filter.
    • Right click on any cell then click Remove filter.

Once filtered, at the bottom right users can find the number of rows being displayed out of the total rows in the table.

Share a filter view

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Apply the filter view .
  3. Copy the URL.
  4. Share the filter view link.

Learn more at the Google Docs Editors Help Center

 


Google, Google Workspace, and related marks and logos are trademarks of Google LLC. All other company and product names are trademarks of the companies with which they are associated.

Was this helpful?

How can we improve it?
true
Print, save, or customize Learning Center guides

Learn how to print Learning Center guides, save them as PDFs, or customize them for your organization.

Search
Clear search
Close search
Google apps
Main menu