Sheet - Team L.C.L Excavation icon

Sheet - Team L.C.L Excavation

Read, update, write and delete data from Smartsheet API

Actions13

Overview

This node operation "Find Column (Using Title)" for the "Manage Smartsheet" resource allows users to locate a specific column within a Smartsheet sheet by providing the column's title. It queries the Smartsheet API to retrieve all columns of the specified sheet and searches for a column whose title exactly matches the given input. If found, it returns the unique identifier of that column.

Common scenarios where this is useful:

  • When you have a sheet ID but only know the column name and need its internal ID for further operations like updating rows or reading data.
  • Automating workflows that require dynamic referencing of columns by their human-readable titles rather than hardcoded IDs.
  • Integrating with other systems where column titles are known but Smartsheet column IDs are not.

Practical example:
You want to update values in a column named "Status" on a particular sheet. First, use this operation to find the column ID of "Status" by specifying the sheet and the column title. Then, use that ID in subsequent steps to update or query rows in that column.

Properties

Name Meaning
Sheet Name or ID Select the target sheet either by choosing from a dropdown list of sheets or by specifying an ID directly. This identifies which sheet to search in.
Column Title The exact title of the column you want to find within the specified sheet.

Output

The output JSON contains:

{
  "columnID": "<column_id>"
}
  • columnID: The unique identifier of the column whose title matches the provided input. This ID can be used in other Smartsheet API calls requiring a column reference.

No binary data is output by this operation.

Dependencies

  • Requires a valid API authentication token credential for Smartsheet API access.
  • The node uses the Smartsheet REST API v2 endpoint https://api.smartsheet.com/2.0/sheets/{sheetId}/columns to fetch columns.
  • The user must have appropriate permissions to read the sheet metadata.

Troubleshooting

  • Error: Column titled "<title>" not found.
    This error occurs if no column with the exact specified title exists in the sheet.
    Resolution: Verify the column title spelling and case sensitivity. Titles must match exactly as they appear in Smartsheet.

  • Sheet ID issues:
    If the sheet ID is invalid or inaccessible, the API call will fail.
    Resolution: Confirm the sheet ID is correct and that the API token has access rights to the sheet.

  • Empty or missing inputs:
    Both "Sheet Name or ID" and "Column Title" are required. Missing these will cause errors.
    Resolution: Ensure both fields are filled before execution.

Links and References

Discussion