Setting up spreadsheet columns to display the results of formulae

To display the results of a formula that you have created in a spreadsheet column:

  1. Right-click a column heading, then select Table Definition. The Table Definition Properties dialog appears.
  2. Locate the spreadsheet column that you want to edit, then click its first row to change the bar or task attribute, or click its second row to change the allocation attribute. A hierarchical drop-down list of attributes is enabled.
  3. Select Formulae from the menu that appears, A series of submenus representing the various formula categories in the project appears.
  4. Select the category that contains the formula you want to display in the spreadsheet column, then select the formula itself. The selected formula appears in the dialog.
  5. Click Close to close the Table Definition Properties dialog and display the results of the selected formula in the column.

Related Topics:

Creating formulae

Categorising formulae