Review Resource Assignments in a Workspace

The Assignment List page at the workspace level displays all of the resources assigned to projects within the workspace.

You can view resource assignments and their data in two different layouts: Grid or Spreadsheet.

Grid

Use the standard Grid layout for a view of total values for your resource assignments and their data. The data is displayed in customizable columns and grouping criteria depending on your needs. Because the Grid layout doesn't include a breakdown of the data over time, you can use this view to report high-level data to stakeholders.

Spreadsheet

Use the Spreadsheet layout to view resource assignments and their data in a customizable table format with a breakdown of values along the timescale configured for the page. Add vertical columns to view general information, dates and durations, and rolled up unit and cost fields for each resource. The same unit and cost fields can be displayed in horizontal spreadsheet rows so that their values can be analyzed along a timescale. Time-phased values for each row roll up to a corresponding Total column.

The first column of the table shows each resource assignment's name. Resources can be grouped by their activity assignments, associated roles, projects, codes, and more. These same fields can also be shown as columns. If a resource is grouped by a role or has an associated role listed in a column, it means that the role is staffed by the resource. If a resource is grouped by a role with a grouping band value of None, or if the associated role column is blank, it means that the resource is directly assigned to the project and has no associated role. If a resource name field is blank, it means that an unstaffed role is assigned to the project. You may need to add a column for role name or ID or group by roles to see which roles are staffed or unstaffed.

You can save your page layouts as named views. Create as many named views as necessary for different displays of your data.

To review resource assignments in a workspace:

  1. Navigate to the workspace resource assignments page
  2. On the Layout menu, select Grid or Spreadsheet.
  3. Select Settings in the toolbar to configure view options such as columns, filters, grouping, timescale, spreadsheet rows, and currency.
  4. Use columns to view resource details and rolled up values.
  5. (Spreadsheet layout only) Use spreadsheet rows to view time-phased unit and cost values. To start the spreadsheet timescale at a specific date, in the Go to field, select a date.
  6. Use the Search field to search for keywords in the table.

Tips