Update Rows in Sheet
smartsheet_update_rowsUpdate existing rows in a Smartsheet sheet by specifying row IDs and cells to change. Optionally lock or expand rows.
Instructions
Update one or more existing rows in a Smartsheet sheet. Each row update specifies the row ID and cells to change. Only provided cells are updated; unspecified cells are left unchanged. Can also lock/unlock rows or change hierarchy.
Args:
sheet_id (number): Target sheet ID
rows (array): Array of row update objects, each containing:
row_id (number): ID of the row to update
cells (array): Array of {column_id, value} cells to update
locked (boolean, optional): Lock or unlock the row
expanded (boolean, optional): Expand or collapse row
Returns: Updated row data and new sheet version.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet_id | Yes | Target sheet ID | |
| rows | Yes |