Info_Cells

Explore individual cell data in Smartsheet rows, offering granular insights into sheet contents.

Table Specific Information

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'


Name	Type	References	Description
Id [KEY]	String		The unique identifier of the column that contains the cell. This is a reference to the parent column in the sheet's schema.
Value	String		The actual content of the cell, which can be a string, number, or boolean, representing the cell's primary data.
DisplayValue	String		The formatted version of the cell's content as displayed to the user in the Smartsheet UI, reflecting applied formats and rules.
ColumnType	String		The type of data or content allowed in the column (for example, text, date, dropdown) as defined in the column's schema.
Formula	String		The formula applied to the cell, if any, used to compute dynamic values based on other cell references.
Format	String		Descriptor specifying the visual formatting of the cell, such as text style, color, or alignment.
ConditionalFormat	String		The formatting applied to the cell based on conditional rules set at the column or sheet level.
Strict	Boolean		Indicates if strict parsing rules are applied to the cell's value. Defaults to true; set to false for more lenient value handling.
SheetId	String		The unique identifier of the sheet to which this cell belongs.
RowId	String		The unique identifier of the row containing this cell, representing its position in the sheet.