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. |