Actions13
- Manage Smartsheet Actions
- Manage Folder Actions
Manage Smartsheet → Find Rows (Using Column Label)
AI-generatedOverview
This node operation allows users to find rows in a specified Smartsheet sheet by searching for a specific value in a column identified by its label. It fetches the sheet data, maps column IDs to their titles, and filters rows where the value in the specified column matches the search query. The output can be returned either as an object or as an array of matching rows. This operation is useful for scenarios where you need to locate specific rows based on column content, such as finding all rows with a particular status or keyword.
Use Case Examples
- Find all rows in a project management sheet where the 'Status' column equals 'Completed'.
- Search for rows in an inventory sheet where the 'Item Name' column matches a specific product name.
Properties
| Name | Meaning |
|---|---|
| Sheet Name or ID | The ID or name of the Smartsheet sheet to search within. This is required to specify which sheet's rows to find. |
| Search Value | The value to search for within the specified column label. Rows containing this value in the target column will be returned. |
| Type | Determines the format of the output. 'Object' returns the rows wrapped in an object, while 'Array Single Item' returns an array of matching rows directly. |
Output
JSON
rows- Array of rows matching the search criteria, each containing rowId, rowNumber, and column values keyed by column titles.
Dependencies
- Smartsheet API with an API key credential
Troubleshooting
If the specified column label does not exist in the sheet, the node throws an error 'Column key "" not found.' Ensure the column label is correct and exists in the sheet.
- 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 selected output type.
- API errors such as authentication failures or rate limits will be logged and can cause the node to fail unless 'Continue On Fail' is enabled.