Actions13
- Manage Smartsheet Actions
- Manage Folder Actions
Manage Smartsheet → Find Row
AI-generatedOverview
This node operation allows users to find rows in a specified Smartsheet sheet based on a search value in a particular column. It is useful for scenarios where you need to locate specific data entries within a sheet, such as finding a row with a matching customer name, order ID, or any other column value. For example, you can search for a row where the 'Status' column equals 'Completed' or find rows matching a specific product code.
Use Case Examples
- Find rows in a project management sheet where the 'Task Name' column matches 'Design Phase'.
- Search for rows in an inventory sheet where the 'SKU' column equals a given product ID.
Properties
| Name | Meaning |
|---|---|
| Sheet Name or ID | The identifier or name of the Smartsheet sheet where the search will be performed. This is required to specify which sheet to query. |
| Column Name or ID | The column within the sheet to search in. The search will look for the specified value in this column. |
| Search Value | The value to search for within the specified column. Rows with this value in the 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 or an empty object if none found. |
Output
JSON
rowId- The unique identifier of the row in Smartsheet.rowNumber- The row number within the sheet.
- Each column title from the sheet is a key, with the corresponding cell value as the value for that key in the row object.
Dependencies
- Smartsheet API with an API key credential
Troubleshooting
- Ensure the sheet ID and column ID are correct and accessible with the provided API credentials.
- If no rows are found, verify the search value matches exactly the cell content in the specified column.
- Errors related to API requests may indicate network issues or invalid credentials; check the API key and network connectivity.