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.
Great!
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.