Applies to

Brandfolder
  • Brandfolder

For more information about plan types and included capabilities, see the Smartsheet Plans page.

Capabilities

Who can use this capability

Owners and Admins can use metasheets to make bulk edits.

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

Metasheets

Metasheets allow editable users to change a group of assets in bulk.

PLANS

  • Brandfolder

For more information about plan types and included capabilities, see the Smartsheet Plans page.

Permissions

Owners and Admins can use metasheets to make bulk edits.

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

Editable users can update and add tags, custom fields, dependent custom fields, asset names, and descriptions via CSV. This feature helps significantly decrease an admin's time spent making sure the correct taxonomy and information are in place on multiple assets. 

Creating a metasheet

  1. Bulk-select the assets you want to update. 
  2. From the bulk actions toolbar, hover over Download and select Download CSV. 
  3. The CSV will download to your device.

Editing a metasheet

  1. Open the new metasheet CSV in a spreadsheet editor of your choice. 
  2. From here, add, update, and delete information within the CSV. 
  3. Editable users can update and add tags, custom fields, dependent custom fields, asset names, and descriptions. Attachment filenames can't be adjusted using Metasheets. 
  4. Rename and save the updated CSV metasheet.
  5. Within Brandfolder, navigate to Settings > Bulk Management. 
  6. Select Upload CSV.
  7. Upload the new metasheet within the import box. 
  8. After the CSV is done processing, the updates will appear in Brandfolder.

Processing time is dictated by the number of assets and information updated. Please allow for a few moments of processing time should this be a large update. We do not recommend updating more than 40,000 rows at once. 

Custom field management in metasheets 

Single and multi-value custom fields can be updated for many assets using metasheets. 

When adding multiple values for a key, the values must be separated by a semicolon ;. Only keys that support multiple values will recognize the semicolon-delimited format. This ensures that keys can not accidentally be assigned more than one value. Do note: that beginning and trailing semicolons will be ignored. Comma delimiting does not work. 

Dependent custom fields 

Dependent custom fields are also managed in bulk using metasheets, but in a different area. Learn more about dependent custom fields. 

The file you upload into metasheets must in CSV format. 

> < ( ) { } [ ] &" *: are reserved characters and cannot be used in any of the pieces of information you are updating. 

When adding multiple values for a key, the values must be separated by a semicolon”;”. For example for the key Channel, you would need to list the values as Direct Mail; E-mail; Website. Only keys that support multiple values will recognize the semicolon-delimited format. This ensures that Keys can not accidentally be assigned more than one value. 

 

 

Was this article helpful?
YesNo