Skip to content
Playback speed:

To complete a complex group project successfully, it’s important to ensure that all group members know what tasks they are responsible for.

When there are numerous tasks that each person must complete, it can sometimes feel confusing and overwhelming.

Filtering your tasks by owner enables each individual group member to see which tasks they must complete without being distracted by tasks that are owned by someone else in the group.

Filtering makes a long, complicated spreadsheet much easier to work with and will help your group stay on task as you work on your project.

In this extension, you will create a filter view in order to clearly and easily see the tasks you own.

You will create a new filter view, choose your own name as the filter criteria, and create another filter view to show both the tasks you own and those owned by everyone in your group.

To begin, go to your Google Drive, and open your Project-Planning spreadsheet.

Begin by highlighting the Task owner column.

Then, create a filter view.

Because filter views need to be turned on by each person viewing a spreadsheet, group members can view a different filter view at the same time.

Click the filter icon.

Under Filter by Values, clear the current values.

Then, select your name.


Now, you can see exactly which tasks you own and must complete.

However, there are some tasks that everyone in the group owns.

You want to remember to work on those, too.

To see tasks that both you and everyone own, create another filter view.

First, turn off the original filter.

You'll still be able to see all of your original data when you turn off the filter view.

Then, create another filter view.

Clear the current values.

Then select your name and All.

Good job!

Now, you can see your own tasks and tasks that you are responsible for helping your group complete.

Now it's your turn. Highlight the Task owner column.

Create a new filter view.

Filter by values, clear the current values, and select your name.

Then, turn off the filter, and add a new filter view for your name and All.

Choose an extension
Add Links to Resources

Use a spreadsheet to keep track of the research you do for your group project so you can easily access it later and cite your sources properly.

Use Conditional Formatting to Show Task Status

Add conditional formatting to your group project spreadsheet.

Check Off Completed Tasks

Create a checklist by adding checkboxes to your project planning spreadsheet.

Invite Group Members to a Meeting

Schedule a meeting, invite people to your meeting, and share a document in your meeting invitation.

Ask for Feedback and Implement Suggestions

Share your project planning spreadsheet with a partner.

Filter Tasks by Owner

Create a filter view in order to clearly and easily see the tasks you own.


Choose one of the videos below to extend the lesson.