View Your Assigned Tasks

To quickly find all tasks that are assigned to you or to someone else, do either of the following:

• To view tasks from one sheet only,use a filter.
• To view tasks across multiple sheets,create a report.

The steps in this article assume that tasks are assigned in columns using a Contact List column type. For more information about column types, please seeUse the Best Column Type for Your Data.

---

View Assigned Tasks on a Single Sheet

To view assigned tasks on a single sheet:

1. Open the sheet that contains the tasks you want to display.
2. From the menu bar click the filter menu and then clickNew Filter.
3. Name the filter (for example, name the filter “My Tasks”).
4. In the Create New Filter form, under Show rows that match, select the following criteria:
   • Assigned To
   • Has any of
5. In theSelect Valuesbox, select the name of the person whose tasks you want to view.
   
   TIP: To create a filter that finds tasks for the collaborator currently viewing the sheet, selectCurrent User. This can be handy if you’re creating a shared filter.
   
6. ClickApply.

The data in the sheet will be filtered to show only tasks assigned to the person whose name you selected in theSelect Valuesbox.

For more information about creating filters, including how to save and share them, seeUsing Filters to Show or Hide Sheet Data.

View Assigned Tasks from Multiple Sheets

If you are tracking projects in multiple sheets and you want to find items assigned to you or someone else in all of them, you’ll use a report.

To create a report that displays all tasks assigned to you or to someone else:

1. On the Navigation Bar, clickSolution Center(plus icon) >Create>Report.
2. SelectRow Report.
3. Name the report (for example, name the report “My Tasks”).

SeeBuild a row report.

When you’re configuring theFilter Criteria, select the contact column you want to validate (e.g. “Assigned To”) and choose the person whose tasks you wish to see.

You can also selectCurrent Userin the filter criteria to display tasks assigned to the person viewing the report (Contact Column > Has Any Of > Current User). This is useful if you want to share a report that others can use to see tasks assigned to them because you won’t have to create a separate report for each collaborator.