Actions
Update Cell
Update cell values in the specified row and column.
External Documentation
To learn more, visit the Smartsheet documentation.
Parameters
Parameter | Description |
---|---|
Allow Partial Success | Select to enable partial success for this bulk operation.See Partial Success for more information. |
Column ID | The column ID of the cell to link. |
Column ID | The ID of the column that the cell is located in. |
Expanded | Indicates whether the row is expanded or collapsed. |
Formula | The formula for a cell. Note that calculation errors or problems with a formula will be retrieved as presented in the UI, for example #CIRCULAR REFERENCE . |
Formula Or Value | Choose between inserting a value or a formula. |
Hyper Link | A link to a report, sheet, or URL. Note, you must set the value attribute to use this parameter. |
Image | Select to set a cell image’s attributes, such as its alternate text (e.g., altText = string). Note, you must set the value attribute to use this parameter. |
Image Alternate text | Alternate text for the image. |
Image Height | Original height (in pixels) of the uploaded image. |
Image ID | Image ID. |
Image width | Original width (in pixels) of the uploaded image. |
Link From Cell | Links in another cell’s value. Smartsheet synchronizes the source cell into this cell.Note: the synchronization may take several minutes.Important: you must set the value attribute to use this parameter. |
Locked | Select to lock the row. |
Override Validation | Select to allow a cell value outside of the validation limits. You must uncheck strict parameter to bypass value type checking. |
Override Validation | Select to allow a cell value outside of the validation limits. |
Report ID | The Report ID. |
Row ID | Row ID of the row being accessed. Can be obtained by using List Search Sheet or Search Sheets actions. |
Row ID | The Row ID of the cell to link. |
Sheet ID | The sheet ID in which the cell to link located at. |
Sheet ID | Sheet ID of the sheet being accessed. |
Sheet ID | Link to Report ID hyperlink. |
Strict | Select for a strict value parsing, See Cell value parsing for details. |
URL | URL of the hyperlink. |
Value | A desired value, a label for a hyperlink you’re inserting, or an empty string if you’re linking to another cell. |
Example Output
Workflow Library Example
Update Cell with Smartsheet and Send Results Via Email
Preview this Workflow on desktop
Was this page helpful?