Cost Column Shell Updating Rules

If a cost sheet column of the same name exists, it is replaced according to the following matrix.

If this template (source):

Is used for this shell (destination):

The template will:

Single Date Source

Column exists

Update the column

Column does not exist

Create column with the same definition

Logical Data source (Formula entry)

Logical Data source Column Exists (Formula entry)

Update and replace the formula

Logical Data source column exists (Manual entry)

Not update the column or formula

Column does not exist

Create column with same definition

Logical Data source (Manual entry)

Logical Data source Column Exists (Manual entry)

Update the column

Logical Data source Column Exists (Formula entry)

Update the column and change it to manual entry

Column does not exist

Create column with same definition

To add or update cost sheet columns using Update Shells:

  1. Go to the Company Workspace tab, and switch to Admin mode.
  2. In the left Navigator, select Templates, and then select Shells.
  3. Open the template that you want to update.
  4. In the left Navigator, select Cost Manager, select Cost Sheet, and open the Cost Sheet template.
  5. From the toolbar, select Menu Options, select Columns, and then select Manage Columns.

    The Cost Sheet Columns window opens.

  6. If applicable, drag and drop the listed columns to the order that you want to use.
  7. Select the column, or columns that you want to use in the update.
  8. From the toolbar, select Update Shells, and choose one of the following:
    • Shells: Use this option to select one or more shells to update. When the update window opens, it lists all shells in the project. You can use Find on Page to isolate the shells you want to update. The find window contains data elements from the Find form that was designed. When you have isolated the shells to update, select Update.
    • All Shells: Use this option to update all shells of that shell type.
    • History: Use this option to view the update history from past updates or cancel a request before the update begins.

    An Alert window opens letting you know that you are about to push changes to the selected shells. There is no undo for the update.

  9. To proceed with the update, select Yes.

Last Published Monday, October 13, 2025