Actions13
- Manage Smartsheet Actions
- Manage Folder Actions
Overview
This node enables managing Smartsheet data, specifically allowing users to update a column within a specified sheet. The "Update Column" operation modifies properties of an existing column such as its title, type, formula, visibility, index position, description, format, and validation settings.
Common scenarios include:
- Renaming a column to better reflect updated data requirements.
- Changing the column type (e.g., from text to date) to enforce correct data entry.
- Adding or updating formulas for calculated columns.
- Hiding columns that are no longer relevant for end-users.
- Adjusting the order of columns by changing their index.
- Adding descriptions or formatting rules to improve sheet usability.
Practical example:
- A project manager wants to rename a "Due Date" column to "Deadline" and change its type to "DATE" to ensure proper date handling in Smartsheet.
Properties
| Name | Meaning |
|---|---|
| Sheet Name or ID | Select the target sheet by name or specify its ID where the column exists. |
| Column ID | The unique identifier of the column to update within the selected sheet. |
| Title | The new title/name for the column. |
| Type | The data type of the column. Options include: ABSTRACT DATETIME, CHECK BOX, CONTACT LIST, DATE, DATETIME, DURATION, MULTI CONTACT LIST, MULTI PICKLIST, PICKLIST, PREDECESSOR, TEXT NUMBER. |
| Additional Fields | Optional extra settings for the column: |
| - Description | Text description of the column's purpose. |
| - Format | Formatting string to control how data appears in the column. |
| - Formula | Formula expression to calculate values in the column. |
| - Hidden | Boolean flag to hide or show the column. |
| - Index | Numeric position index to reorder the column within the sheet. |
| - Validation | Boolean flag to enable or disable validation rules on the column. |
Output
The node outputs JSON data representing the updated column object returned by the Smartsheet API. This includes all properties of the column after the update, such as its ID, title, type, formula, visibility, index, description, format, and validation status.
No binary data output is produced by this operation.
Dependencies
- Requires an active connection to the Smartsheet API via an API key credential configured in n8n.
- The node uses the Smartsheet REST API v2 endpoint
https://api.smartsheet.com/2.0. - Proper permissions on the Smartsheet account to modify sheets and columns are necessary.
Troubleshooting
- Error: "Column not found" — Ensure the provided Column ID corresponds to an existing column in the specified sheet.
- Invalid type or formula errors — Verify that the column type is valid and that any formula syntax matches Smartsheet's formula requirements.
- Permission denied or authentication errors — Confirm that the API key credential has sufficient access rights and is correctly configured.
- Index out of range — When specifying the index, ensure it is within the valid range of columns in the sheet.
- Empty or missing required fields — Make sure all required properties like Sheet ID, Column ID, Title, and Type are provided.
If the node fails and "Continue On Fail" is disabled, execution will stop with an error message describing the issue.