Specific Task Data dialog
You use the Specific Task Data dialog to indicate the task(s) to which you want the currently selected field to refer. You can choose to refer to a specific task according to its position on the bar, or to the tasks on a bar that have been assigned specific code library entries.

To access the Specific Task Data dialog, click the Settings button on the Column Definitions tab of the Table Definition Properties dialog.

Field | Description |
---|---|
None | Click this radio button to remove the specific task data settings from the selected field. |
Specific task | Click this radio button if you want the selected field to refer to a specific task according to its position on a bar. |
Code library filtered task(s) | Click this radio button if you want the selected field to refer to tasks on a bar that have been assigned specific code library entries. |
Rollup values where more than one task matches |
If you make the field refer to tasks on a bar that have been assigned specific code library entries, the field will refer to all tasks on the bar to which the code has been assigned. Select this check box to roll up values into a single figure, or clear the check box to display values for each individual task in a comma-separated list.
Note that values are only summed into a single figure where it makes sense to do so, for example in the case of financial values. |
Task number | Specify the number of the task to which you want the selected field to refer, for example the second or fourth task on the bar. |
Last task | Select this check box if you want the selected field to refer to the last task on each bar. |
Code library filtered task(s) |
Select the code library entry or entries with which to filter tasks.
The selected field will refer to all tasks on a bar that have been assigned one or more of the selected entries, unless you select the All entries must match check box, in which case the field will refer only to those tasks on a bar that have been assigned all of the selected entries. |
All entries must match | If you have selected more than one code library entry in the above field, select this check box to specify that the selected field should refer to those tasks on a bar that have been assigned all of the selected entries, or clear the check box to specify that it should refer to all tasks on a bar that have been assigned one or more of the selected entries. |
How do I...

- Click the Specific task radio button.
- Specify the number of the task to which you want the field to refer - for example the second or fourth task on the bar - in the Task number field, or select the Last task check box to make the field refer to the last task on each bar.
- Click OK.

- Click the Code library filtered task(s) radio button.
- Select the code library entry or entries with which to filter tasks.
- If you have selected more than one code library entry, select the All entries must match check box to specify that the selected field should refer to those tasks on a bar that have been assigned all of the selected entries, or clear the check box to specify that it should refer to all tasks on a bar that have been assigned one or more of the selected entries.
- If more than one task matches your code library criteria on a bar, the task details are displayed in the spreadsheet cell in a comma-separated list. You can select the Rollup values where more than one task matches check box to sum the values into a single figure.
- Click OK.

- Click the None radio button.
- Click OK.
Displaying information about specific tasks in the spreadsheet