Update cell values in the specified rows, expand/collapse the specified rows, or modify the position of specified rows (including indenting/outdenting).

For more information regarding changing row positions, see location-specifier attributes.

External Documentation

To learn more, visit the Smartsheet documentation.

​
Parameters

ParameterDescription
Allow Partial SuccessSelect to enable partial success for this bulk operation.See Partial Success for more information.
ExpandedIndicates whether the row is expanded or collapsed.
LockedSelect to lock the row.
Override ValidationSelect to allow a cell value outside of the validation limits.
Row IDRow ID of the row being accessed. Can be obtained by using List Search Sheet or Search Sheets actions.
Sheet IDSheet ID of the sheet being accessed.
cellsEnter the content of the cells inside a list [] , each cell should be an object {}.For further information about the options for each cell visit, Smartsheet’s documentation.Example: [ { "columnId": 11111111, "value": "Updated Value", "image":{ "altText": "The Actual Alt text", "height": 50, "id": "{image ID}", "width": 50 } }, { "columnId": 22222222, "value": "Updated Value", "strict": "true", "overrideValidation": "true" } ]

​
Example Output

{
	"message": "SUCCESS",
	"resultCode": 0,
	"result": [
		{
			"id": 0,
			"rowNumber": 1,
			"parentRowNumber": 0,
			"parentId": 0,
			"expanded": true,
			"createdAt": "2019-08-24T14:15:22Z",
			"modifiedAt": "2019-08-24T14:15:22Z",
			"cells": [
				{
					"columnId": 0,
					"columnType": "string",
					"value": "string",
					"displayValue": "string"
				}
			],
			"version": 0
		}
	]
}

​
Workflow Library Example

Update Row with Smartsheet and Send Results Via Email

Workflow Library

Preview this Workflow on desktop

Was this page helpful?