# SheetColumns ## Documentation The columns of the sheets: their title, type and position. A filter on sheet_id reads one sheet only. An insert adds a column, an update renames or moves it, a delete removes it with its values. - Catalog: `Smartsheet` - Schema: `Sheets` - Primary Keys: `sheet_id, column_id` Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `SheetColumns` 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 | |---|:---:|---|:---:|---| | `column_id` | `int64` | | ☑ | The id of the column. | | `description` | `varchar2` | | ☐ | The description of the column. | | `formula` | `varchar2` | | ☐ | The formula of a column formula. | | `hidden` | `char` | | ☐ | Whether the column is hidden. | | `index` | `int32` | | ☑ | The position of the column, 0 for the first. | | `locked` | `char` | | ☐ | Whether the column is locked against changes. | | `options` | `varchar2` | | ☐ | The choices of a picklist, separated by a line break. | | `primary` | `char` | | ☑ | Whether this is the primary column, which every sheet has exactly one of. | | `sheet_id` | `int64` | | ☑ | The sheet of the column. | | `symbol` | `varchar2` | | ☐ | The symbol set of a checkbox or picklist shown as symbols. | | `system_column_type` | `varchar2` | | ☐ | For a column Smartsheet fills itself: AUTO_NUMBER, CREATED_BY, CREATED_DATE, MODIFIED_BY or MODIFIED_DATE. | | `title` | `varchar2` | | ☑ | The title shown above the column. | | `type` | `varchar2` | | ☑ | The type: TEXT_NUMBER, DATE, DATETIME, CONTACT_LIST, MULTI_CONTACT_LIST, CHECKBOX, PICKLIST, MULTI_PICKLIST, DURATION, PREDECESSOR or ABSTRACT_DATETIME. | | `validation` | `char` | | ☐ | Whether values outside the choices are refused. | | `version` | `int32` | | ☐ | The version of the column: 0 for a classic column, 1 or 2 for a multi-contact or multi-picklist column. | | `width` | `int32` | | ☐ | The width in pixels. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `sheet_id` | [[Sheets-Sheets\|Sheets.Sheets]] | `sheet_id` | Declared by the connector, not enforced by the platform | ## Referenced By The columns of these tables refer to a row of this table. | Table | Columns | Guarantee | |---|---|---| | [[Sheets-SheetCells\|Sheets.SheetCells]] | `sheet_id`, `column_id` | Declared by the connector, not enforced by the platform | | [[Sheets-SheetCrossSheetReferences\|Sheets.SheetCrossSheetReferences]] | `source_sheet_id`, `end_column_id` | In words only: The last column of the range in the source sheet; null for whole rows. | | [[Sheets-SheetCrossSheetReferences\|Sheets.SheetCrossSheetReferences]] | `source_sheet_id`, `start_column_id` | In words only: The first column of the range in the source sheet; null for whole rows. |