# Sheets ## Documentation The sheets the user can see: a grid of rows and columns, like a spreadsheet. An insert creates a sheet in a folder or a workspace with one primary column; an update renames it; a delete removes it with all its rows. - Catalog: `Smartsheet` - Schema: `Sheets` - Primary Keys: `sheet_id` Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `Sheets` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `access_level` | `varchar2` | | ☐ | What the user may do with the sheet: VIEWER, COMMENTER, EDITOR, EDITOR_SHARE, ADMIN or OWNER. | | `created_at` | `datetime` | | ☐ | When the sheet was created, UTC. | | `folder_id` | `int64` | | ☐ | Write only, on insert: the folder to create the sheet in. Give this or workspace_id. | | `modified_at` | `datetime` | | ☐ | When the sheet was last changed, UTC. | | `name` | `varchar2` | | ☑ | The name of the sheet. | | `permalink` | `varchar2` | | ☐ | The link that opens the sheet in Smartsheet. | | `primary_column_title` | `varchar2` | | ☐ | Write only, on insert: the title of the one column of the new sheet, its primary column. Name when left empty. | | `sheet_id` | `int64` | | ☑ | The id of the sheet. | | `workspace_id` | `int64` | | ☐ | Write only, on insert: the workspace to create the sheet in, at its top. Give this or folder_id. | ## Referenced By The columns of these tables refer to a row of this table. | Table | Columns | Guarantee | |---|---|---| | [[Platform-Favorites\|Platform.Favorites]] | `object_id` | In words only: A sheet when type is sheet. | | [[Platform-Webhooks\|Platform.Webhooks]] | `scope_object_id` | In words only: A sheet when scope is sheet, and the user can see it. | | [[Sheets-SheetAttachments\|Sheets.SheetAttachments]] | `sheet_id` | Declared by the connector, not enforced by the platform | | [[Sheets-SheetAutomationRules\|Sheets.SheetAutomationRules]] | `sheet_id` | Declared by the connector, not enforced by the platform | | [[Sheets-SheetColumns\|Sheets.SheetColumns]] | `sheet_id` | Declared by the connector, not enforced by the platform | | [[Sheets-SheetCrossSheetReferences\|Sheets.SheetCrossSheetReferences]] | `sheet_id` | Declared by the connector, not enforced by the platform | | [[Sheets-SheetCrossSheetReferences\|Sheets.SheetCrossSheetReferences]] | `source_sheet_id` | In words only: Holds for a source sheet the user can see. | | [[Sheets-SheetDiscussions\|Sheets.SheetDiscussions]] | `sheet_id` | Declared by the connector, not enforced by the platform | | [[Sheets-SheetRows\|Sheets.SheetRows]] | `sheet_id` | Declared by the connector, not enforced by the platform | | [[Sheets-SheetShares\|Sheets.SheetShares]] | `sheet_id` | Declared by the connector, not enforced by the platform | | [[Sheets-SheetSummaryFields\|Sheets.SheetSummaryFields]] | `sheet_id` | Declared by the connector, not enforced by the platform | | [[Workspaces-FolderItems\|Workspaces.FolderItems]] | `id` | In words only: A sheet when resource_type is sheet. |