Gain Insight into Resource Allocation with Project Resource View

A resource view provides a visual way to track and review how people in your Smartsheet plan (resources) are allocated across the projects they're working on. Use resource views to make decisions about resource workloads.

In this article:

For information about how to set up and enable resource management, see Resource Management and Allocation.

Before You Begin

Before you can view resources in a resource view, team members must be assigned to resource management-enabled project sheets as described in the Managing Resources article.

Your Smartsheet System Admin must also do the following:

  • Designate you to be a resource viewer on the account
  • Ensure that the  people who you want to track are included on the account—they can be unlicensed users, but they must be included on the account. (For more information, see the User Management article.)

NOTE: This feature is not available for single-user plan types. (Not sure which plan type you have? See Identify Your Smartsheet Plan and User Type.)


Show Resources in Project Resource View

  1. From a sheet with resource management enabled, click Gantt View in the toolbar, and click the Project Resource View icon Project Resource View icon (under the Share button) on the right side of the window.
  2. From here, you can review the workloads of all resources assigned to tasks in that sheet.
  3. Click the name of the resource to review their allocation by project.

<update image>

TIP: Click the allocation alert icon to display the project resource view.

View Resources Across Multiple Sheets

Resource viewers can review allocation across all sheets that have the feature enabled. To do this:

  1. Click the Menu icon (upper-left corner of the Smartsheet window) > Home.

  2. Right-click the Resource Views command, and click Create New View.
  3. Select the sheets or resources for which you want to see allocation and click OK.

    NOTE: If a resource is allocated to tasks in sheets that aren't shared to you, the allocation across all of these sheets will be combined and listed under Other Sheets in the Resource View.

The allocation alert icon will be displayed next to any task assigned to at least one overallocated resource. Scroll through the timeline to see the sheets where the resource is assigned to tasks, and consider reassigning some of their tasks to others.

Share or Export Resource View

To export and share the resource view,

  1. Click the Menu icon (upper-left corner of the Smartsheet window) > Home.

  2. Under Resource Views, click the view, and do either of the following:
    • To email the resource view as a Microsoft Excel (.xls) attachment, click the envelope icon  .
    • To download a Microsoft Excel (.xls) file of the resource view, click the export icon  . Click on the date range to change the time frame that is displayed in the view.

Create a Custom Resource View

Use a custom resource view to create a more relevant data set:

  1. Click the Menu icon (upper-left corner of the Smartsheet window) > Home.

  2. Right-click the Resource Views command, and click Create New View.
  3. Choose the desired filter:
    • By User will show all projects where the specified resources are assigned to tasks.
    • By Project will show a list of resources assigned to tasks in the specified projects. The view will include the other projects where those resources are assigned so you can identify potential scheduling issues.
    • By Groups will show all projects with tasks assigned to members of the group.
  4. Click OK.
Was this article helpful?
YesNo