Actions13
- Manage Smartsheet Actions
- Manage Folder Actions
Manage Smartsheet → Update Row (Using Column Name)
AI-generatedOverview
This node operation updates a specific row in a Smartsheet sheet by using column names to specify the values to update. It is useful when you want to modify existing row data in a Smartsheet sheet without needing to know the column IDs, only the column names. For example, you can update a row's status or any other column by providing the row ID and a JSON string mapping column names to new values.
Use Case Examples
- Updating the status and priority columns of a specific row in a project management sheet by specifying the row ID and a JSON object with column names and their new values.
- Modifying contact information in a CRM sheet by updating the row with new phone number and email address using column names.
Properties
| Name | Meaning |
|---|---|
| Sheet Name or ID | The identifier of the Smartsheet sheet where the row to be updated exists. It can be selected from a list or specified using an expression. |
| Row ID | The unique identifier of the row in the sheet that you want to update. |
| Columns (Name and Value Pair) | A JSON string representing the column names and their corresponding new values to update in the specified row. |
Output
JSON
id- The ID of the updated row.cells- An array of cell objects representing the updated columns and their new values in the row.
Dependencies
- Requires an API key credential for Smartsheet API authentication.
Troubleshooting
- Error 'Column - {columnName} not found': This occurs if a specified column name in the JSON string does not exist in the sheet. Verify the column names are correct and match exactly.
- Invalid JSON in 'Columns (Name and Value Pair)': Ensure the input is a valid JSON string mapping column names to values.
- Row ID not found: Verify the row ID exists in the specified sheet.
- API request failures: Check network connectivity and API key validity.
Links
- Smartsheet API Documentation - Official API documentation for Smartsheet, useful for understanding API endpoints and data structures.