Info_Cells
Query Smartsheet Cells. A collection of Cells comprises each Row in a Sheet.
Table Specific Information
Select
This view returns details for Cells of a specified Row. The SheetId and RowId parameters are always required.
Retrieve Cells.
SELECT * FROM Info_Cells WHERE SheetId = '2940085806098308' AND RowId = '6773684447799172'
Columns
Name | Type | References | Description |
Id [KEY] | String | The Id of the column that the cell is located in. | |
Value | String | The value of the cell. A string, a number, or a boolean value. | |
DisplayValue | String | Visual representation of cell contents as presented to the user in the UI. | |
ColumnType | String | The type definition on the Column object. | |
Formula | String | The formula for a cell, if set. | |
Format | String | The format descriptor. | |
ConditionalFormat | String | The format descriptor describing the conditional formatting of the cell. | |
Strict | Boolean | Set to false to enable lenient parsing. Defaults to true. This attribute can be specified in a request, but will never be present in a response. | |
SheetId | String | The sheet Id. | |
RowId | String | The row Id. |