Power BI Connector for Smartsheet

Build 23.0.8839


Query Smartsheet Cells. A collection of Cells comprises each Row in a Sheet.

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839