Sheet - Team L.C.L Excavation icon

Sheet - Team L.C.L Excavation

Read, update, write and delete data from Smartsheet API
Join our community

Actions13

Overview

The "Find Row" operation in the "Manage Smartsheet" resource allows users to search for rows within a specified Smartsheet sheet based on a value in a particular column. This node fetches the entire sheet data, then filters rows where the chosen column's value matches the search query. It supports returning results either as an array of matching rows or wrapped inside an object.

This operation is useful when you need to locate specific data entries in a Smartsheet by searching for known values in columns, such as finding a row with a particular customer name, order ID, or status. For example, you might use it to find all rows where the "Status" column equals "Completed" or to retrieve the row corresponding to a specific invoice number.

Properties

Name Meaning
Sheet Name or ID Select the target sheet by name or specify its ID where the search will be performed.
Column Name or ID Choose the column within the sheet to search in by name or ID.
Search Value The exact value to look for in the selected column.
Type Determines the format of the output:
- Object: Returns the matched rows wrapped inside an object.
- Array Single Item: Returns an array of matched rows directly.

Output

The output JSON contains the rows from the specified sheet that match the search criteria. Each row object includes:

  • rowId: The unique identifier of the row.
  • rowNumber: The position of the row in the sheet.
  • Columns mapped by their titles with their respective cell values.

If multiple rows match, they are returned as an array. Depending on the "Type" property, the output is either:

  • An array of row objects (if "Array Single Item" is selected).
  • An object containing a rows property which holds the array of matched rows (if "Object" is selected).

No binary data is produced 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.
  • The node dynamically loads available sheets and columns via API calls to assist user selection.

Troubleshooting

  • No rows found: If no rows match the search value, the output will be an empty array or an object with an empty rows array depending on the "Type" setting.
  • Invalid Sheet or Column ID: Selecting a non-existent sheet or column will cause errors. Ensure the sheet and column exist and are accessible with the provided credentials.
  • API Rate Limits or Connectivity Issues: Network problems or hitting Smartsheet API rate limits may cause request failures. Check network connectivity and API usage quotas.
  • Incorrect Data Types: The search value must exactly match the cell value type (e.g., string vs number). Mismatches may result in no matches.
  • Error Messages: Common error messages include:
    • "Column key \"<columnId>\" not found." — The specified column ID does not exist in the sheet.
    • "No rows specified" — Not applicable here but common in other operations; ensure required inputs are provided.

To resolve errors, verify input parameters, check API credentials, and confirm the sheet structure in Smartsheet.

Links and References

Discussion