Sheet - Team L.C.L Excavation icon

Sheet - Team L.C.L Excavation

Read, update, write and delete data from Smartsheet API

Actions13

Manage Smartsheet → Update Column

AI-generated

Overview

This node operation updates a column in a specified Smartsheet sheet. It allows users to modify the column's title, type, and additional optional fields such as description, format, formula, hidden status, index, and validation. This operation is useful for managing and customizing the structure of Smartsheet sheets programmatically, for example, when adjusting column properties to reflect changes in project requirements or data organization.

Use Case Examples

  1. Updating the title and type of a column in a project management sheet to better categorize task information.
  2. Changing the format or adding a formula to a column to automate calculations within the sheet.

Properties

Name Meaning
Sheet Name or ID The identifier of the Smartsheet sheet where the column to be updated exists. This can be selected from a list or specified via an expression.
Column ID The unique identifier of the column to update within the specified sheet.
Title The new title for the column being updated.
Type The data type of the column, such as ABSTRACT_DATETIME, CHECKBOX, CONTACT_LIST, DATE, DATETIME, DURATION, MULTI_CONTACT_LIST, MULTI_PICKLIST, PICKLIST, PREDECESSOR, or TEXT_NUMBER.
Additional Fields Optional additional properties for the column such as description, format, formula, hidden status, index, and validation.

Output

JSON

  • id - The unique identifier of the updated column.
  • title - The updated title of the column.
  • type - The updated type of the column.
  • description - The description of the column if provided.
  • format - The format of the column if provided.
  • formula - The formula applied to the column if provided.
  • hidden - The hidden status of the column.
  • index - The index position of the column in the sheet.
  • validation - The validation status of the column.

Dependencies

  • Smartsheet API with an API key credential

Troubleshooting

  • Ensure the Sheet ID and Column ID are correct and exist in the Smartsheet account.
  • Verify that the API key credential used has sufficient permissions to update columns in the specified sheet.
  • Check that the column type and additional fields are valid according to Smartsheet API specifications.
  • Common error messages include 'Column not found' if the Column ID is invalid, or permission errors if the API key lacks access rights.

Links

Discussion