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 → Add New Column

AI-generated

Overview

This node operation allows users to add a new column to a specified Smartsheet sheet. It is useful for dynamically modifying the structure of a Smartsheet by adding columns with specific attributes such as title, type, and additional optional settings like description, format, formula, visibility, index, and validation. Practical examples include adding a new date column to track deadlines or a checkbox column for task completion status.

Use Case Examples

  1. Add a new 'Due Date' column of type DATE to a project management sheet.
  2. Add a 'Completed' column of type CHECKBOX to a task tracking sheet with a description and validation enabled.

Properties

Name Meaning
Sheet Name or ID The identifier or name of the Smartsheet sheet where the new column will be added. This can be selected from a list or specified using an expression.
Title The title or name of the new column to be added to the sheet.
Type The data type of the new 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 settings for the new column, including description, format, formula, hidden status, index position, and validation flag.

Output

JSON

  • id - The unique identifier of the newly added column.
  • title - The title of the newly added column.
  • type - The data type of the newly added column.
  • description - The description of the newly added column, if provided.
  • format - The format of the newly added column, if provided.
  • formula - The formula applied to the newly added column, if provided.
  • hidden - Indicates if the newly added column is hidden.
  • index - The position index of the newly added column in the sheet.
  • validation - Indicates if validation is enabled for the newly added column.

Dependencies

  • Smartsheet API key credential

Troubleshooting

  • Ensure the provided Sheet ID or name is correct and accessible with the API key.
  • Verify that the column title is unique within the sheet to avoid conflicts.
  • Check that the column type is valid and supported by Smartsheet.
  • If using formulas or validation, ensure the syntax and logic are correct according to Smartsheet's API specifications.
    Common error messages include 'Column titled "" not found' or API request failures due to invalid parameters or permissions. Verify the input parameters and API credentials to resolve these issues.

Links

  • Smartsheet API Documentation - Official API documentation for Smartsheet, useful for understanding column types and additional field options.

Discussion