Applies to

Smartsheet

Capabilities

Who can use this capability

  • Owner

  • Admin

  • Editor

  • Viewer

View your assigned tasks

View your assigned tasks by creating filters or reports.

Who can use this?

Plans:

  • Smartsheet

Permissions:

  • Owner

  • Admin

  • Editor

  • Viewer

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

To quickly find tasks assigned to you or someone else:

  • Use a filter: To view tasks from one sheet only
  • Create a report: To view tasks across multiple sheets

The steps in this article assume that tasks are assigned in columns using a Contact List column type. For more information, see Column types


View assigned tasks on a single sheet

  1. Open the sheet that contains the tasks you want to display.
  2. From the menu bar, select the Filter > New Filter.
  3. Name the filter.
  4. In the Create New Filter form, select:
    • Assigned To
    • Is one of
  5. In the Select Values box, select the name of the person whose tasks you want to view.

To create a filter that finds tasks for the collaborator currently viewing the sheet, select Current User. This can be handy if you’re creating a shared filter.

  1. Select Apply.
Brandfolder Image
Create New Filter form

The data in the sheet will be filtered to show only tasks assigned to the person whose name you selected in the Select Values box. 

What you can do with filters in a sheet depends on your sharing permissions. For more information, see Create a filter to show or hide data


View assigned tasks from multiple sheets

Use reports to track projects in multiple sheets and find items assigned to you or someone else.

There are two types of reports, see Report types.

To create a report: 

  1. Go to the menu bar in Smartsheet and select the plus icon.
Brandfolder Image
Plus icon to add content
  1. Select Report, and choose the type of report you want.
Brandfolder Image
Choose a report type menu
  1. Name the report.
  2. In the Report Builder form:
    • In Sheet, select the sheets that include the tasks you want to find.
    • In Columns,  select the Assigned To (or the Contact List column name containing the assignees).
    • In the Filters, select the name of the person whose tasks you want to view.

To create a filter that finds tasks for the collaborator currently viewing the sheet, select Current User. This can be handy if you’re creating a shared filter.

For more information, see Build a row report and Create filter criteria in Report Builder

Was this article helpful?
YesNo