Spreadsheet tab of the Customize View Dialog Box of the Assignments Page

Overview

Use this tab to modify your assignment spreadsheet.

Screen Elements

Available Columns list

The list of columns available for display.

Search

Enables you to perform a search based on the value you enter in the search bar.

Select Items (Ctrl+Shift+Right Arrow)

Adds the selected item or items from the available list to the selected list.

Deselect Items (Ctrl+Shift+Left Arrow)

Removes the selected item or items from the selected list.

Selected Columns list

The columns you selected from the Available Columns list. Double-click a column in the Selected Columns list to remove it from the list. If the view includes pinned columns, they are listed first and separated from the other columns in the list.

Move Item Up

Advances the selected item up in the sequence (moves a table column to the left).

Move Item Down

Advances the selected item down in sequence (moves a table column to the right).

Options section

Start Date list

Determines the start date of the date range.

Current Date: Enables you to specify that the start date for the search should be a given number of days, weeks, months, quarters, or years before or after the current date.

Earliest Project Date: Enables you to set the start date of the search to equal the earliest scheduled start date of all loaded projects.

Custom Date: Enables you to select the exact start date for the date range.

Finish Date list

Determines the finish date of the date range.

Start Date: Enables you to specify that the finish date for the search should be a given number of days, weeks, months, quarters, or years after the start date for the range.

Latest Project Date: Enables you to specify that the finish date for the search should be the date of the latest scheduled finish date of all loaded projects.

Custom Date: Enables you to select the exact end date for the date range.

Calculate average for units and costs option

Determines whether to calculate the average for units and costs.

Divide values by: The number by which the average is divided. This field is only available if the corresponding option is selected.

Timescale section

Timescale list

The Gantt chart time interval options. Select from one of the following intervals:

Week/Day: The Gantt View is divided into weeks which are then divided into days.

Month/Week: The Gantt View is divided into months which are then divided into weeks.

Quarter/Month: The Gantt View is divided into quarters which are then divided into months.

Year/Month: The Gantt View is divided into years which are then divided into months.

Year/Quarter: The Gantt View is divided into years which are then divided into quarters.

Financial Period: The Gantt chart is divided into years which are then divided into financial periods.

Getting Here

  1. Click Resources.
  2. On the Resources navigation bar, click Assignments.
  3. Click the Views menu and select Manage Views....
  4. In the Customize View dialog box, click Spreadsheet.

Related Topics

About Activity Views

Working with Activity Views


Last Published Wednesday, July 10, 2024