# SheetCells ## Documentation The contents of the sheets, one row per filled cell: the value of one column in one row. A filter on sheet_id reads one sheet only. An insert or update sets the value of a cell, a delete empties it. - Catalog: `Smartsheet` - Schema: `Sheets` - Primary Keys: `sheet_id, row_id, column_id` Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `SheetCells` 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 column of the cell. | | `column_title` | `varchar2` | | ☐ | The title of the column, for reading; the column is identified by column_id. | | `column_type` | `varchar2` | | ☐ | The type of the column. | | `display_value` | `varchar2` | | ☐ | The value as the sheet shows it, such as the name of a contact or a formatted number. | | `formula` | `varchar2` | | ☐ | The formula of the cell, when it has one. | | `hyperlink_url` | `varchar2` | | ☐ | The URL of a hyperlink in the cell. | | `row_id` | `int64` | | ☑ | The row of the cell. | | `row_number` | `int32` | | ☐ | The number of the row as the sheet shows it. | | `sheet_id` | `int64` | | ☑ | The sheet of the cell. | | `value_boolean` | `char` | | ☐ | The value of a CHECKBOX column. | | `value_date` | `datetime` | | ☐ | The value as a date, in a DATE column; a date without time or time zone. | | `value_number` | `decimal` | | ☐ | The value as a number, when it is one. | | `value` | `varchar2` | | ☐ | The stored value as text: a number, a date as yyyy-mm-dd, true or false, or an e-mail address for a contact. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `sheet_id`, `column_id` | [[Sheets-SheetColumns\|Sheets.SheetColumns]] | `sheet_id`, `column_id` | Declared by the connector, not enforced by the platform | | `sheet_id`, `row_id` | [[Sheets-SheetRows\|Sheets.SheetRows]] | `sheet_id`, `row_id` | Declared by the connector, not enforced by the platform |