Control Center Global Updates: Columns

With Global Updates in Control Center, you can make column-level changes to your project sheets and templates with options to Add new column or Modify existing column.

Add a new column

There are two ways to use Global Updates to add a new column. You can create a new column or use an existing one from the template.

Option 1: Create a new column

Use Global Updates to create and add new columns to a template. Run the Global Update to update existing projects.

1. Go to Control Center > Manage Program in the upper-right corner
2. Select Global Updates

Brandfolder Image

3. Select New Update in the upper-right corner
4. Select Add New Column > Next

Brandfolder Image

5. Name your update and select the blueprint and template you want to use

Brandfolder Image

6. Select Create a new column (default). 

Brandfolder Image

7. Fill in the Column Title field and select the Column Type.

Brandfolder Image

8. Optional: Select Advanced to access Column State, Column Styles, Format, and Column Position options.
9. Be sure to test and validate your changes before applying the Global Update.

Option 2: Use an existing column from the template

Use this option if you manually added a new column to your source template, and you want to push the new column to already provisioned projects in your Control Center portfolio.

Use this method to apply a column property (such as currency or decimal places) to an existing column.

1. Add the new column to your template and configure it as desired
2. Navigate to Control Center > Manage Program > Global Updates > New Update
3. Select Add New Column > Next

Brandfolder Image

4. Name your update and select the blueprint and template you want to use
5. Select Use an existing column from the template

Brandfolder Image

6. Select the column you created from the Add Column dropdown. If you don’t see the new column, select Refresh.
7. Optional: Select Advanced to access Column State, Column Styles, Format, and Column Position options.
8. Be sure to test and validate your changes before applying the Global Update.

Modify an existing column

You can use Global Updates to modify existing data in active projects, like adjusting column formatting, updating a dropdown column, and adjusting references in a formula

To make a change:

1. Navigate to Control Center > Manage Program > Global Updates > New Update
2. Select Modify Existing Column > Next

Brandfolder Image

3. Name your update and select the blueprint and template you want to use.
4. Select the column you want to update. 

Brandfolder Image

5. Select one (or both) of the options:

• Change column properties (name, type, options, index)
• Change column cell data

6. Enter the details for your update

Brandfolder Image

7. Optional: Select Advanced to access Column State, Column Styles, Format, and Column Position options.
8. Be sure to test and validate your changes before applying the Global Update.

To implement a column formula with a Modify Existing Column Global Update, add the column formula to your template sheet first. Once the source column has a column formula, that column formula can be applied to existing projects.

You can't modify Auto-Number columns with a Modify Existing Column Global Update.

Modifying column data

InYou can use Global Updates to modify existing data in active projects, add new data, or update column values. To apply Global Updates:

• Create a Modify Existing Column update.
• Choose the option to Change column cell data.
• Select a value from the desired column.
• Select Add New Change.
• Enter a new static value or use a formula.

When using formulas in Global Updates, apply @row notation for row-level references.

Limitations of Advanced options

Keep the following in mind when using Advanced options:

• When you adjust the column position, you can't immediately add a column between the Primary column and the column to its right. This is because this is where profile data name and value pairs are stored.
• Conditional formatting rules aren't copied to the project sheets.
• Certain formatting options aren't available in Advanced options. These include:
  • Currency
  • Percentage
  • Thousands separator
  • Decimal places
  • Date format

If you want to apply any of the above changes to your projects, update your source templates. The new formatting is included in all newly provisioned projects. After updating source templates, use the Use an existing column option to update existing projects.