Info_Sheets
Query Smartsheets Sheets. A Sheet can exist in the Sheets folder for the user (Home), in a Folder, or in a Workspace. It is comprised of Columns, Rows, and Cells, and may optionally contain Attachments and Discussions.
Table Specific Information
Select
Retrieve all Sheets.
SELECT * FROM Info_Sheets
Retrieve Sheets located in a specific Folder.
SELECT * FROM Info_Sheets WHERE FolderId = '2928085806875091'
Retrieve Sheets located in a specific Workspace.
SELECT * FROM Info_Sheets WHERE WorkspaceId = '1928085806875098'
Columns
Name | Type | References | Description |
Id [KEY] | String | The unique identifier of the sheet. | |
Name | String | The name of the sheet. | |
Owner | String | Email address of the sheet owner. | |
OwnerId | String | User Id of the Sheet owner. | |
Permalink | String | URL that represents a direct link to the sheet in Smartsheet. | |
SourceId | String | The Id of the Sheet or Template from which the enclosing sheet was created. | |
SourceType | String | The type of the source object. Possible values: sheet or template. | |
CreatedAt | Datetime | Time that the sheet was created. | |
ModifiedAt | Datetime | Time that the sheet was modified. | |
Version | Long | A number that is incremented every time a sheet is modified. | |
TotalRowCount | Long | The total number of rows in the sheet. | |
AccessLevel | String | User permissions on the sheet. | |
ReadOnly | Boolean | Whether the Sheet belongs to an expired trial. | |
GanttEnabled | Boolean | Whether Gantt is enabled. | |
DependenciesEnabled | Boolean | Whether dependencies are enabled. | |
ResourceManagementEnabled | Boolean | Whether resource management is enabled. | |
Favorite | Boolean | Whether the user has marked this sheet as a favorite in their Home tab. | |
ShowParentRowsForFilters | Boolean | Whether the show parent rows option is enabled for the filters. | |
FromId | String | The Id of the Template from which to create the Sheet. | |
WorkspaceId | String | The Id of the workspace. | |
FolderId | String | The Id of the folder. |