# SheetCrossSheetReferences ## Documentation The named ranges of other sheets which the formulas of a sheet refer to. A filter on sheet_id reads one sheet only. - Catalog: `Smartsheet` - Schema: `Sheets` - Primary Keys: `cross_sheet_reference_id` This is a read-only table. The Smartsheet API may not support changing the data or the Invantive UniversalSQL driver for Smartsheet does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Smartsheet API. ## Table Columns The columns of the table `SheetCrossSheetReferences` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `cross_sheet_reference_id` | `int64` | | ☑ | The id of the reference. | | `end_column_id` | `int64` | | ☐ | The last column of the range; null for whole rows. | | `end_row_id` | `int64` | | ☐ | The last row of the range; null for whole columns. | | `name` | `varchar2` | | ☐ | The name the formulas use. | | `sheet_id` | `int64` | | ☑ | The sheet whose formulas use the reference. | | `source_sheet_id` | `int64` | | ☐ | The sheet the range is in. | | `start_column_id` | `int64` | | ☐ | The first column of the range; null for whole rows. | | `start_row_id` | `int64` | | ☐ | The first row of the range; null for whole columns. | | `status` | `varchar2` | | ☐ | Whether the reference works: OK, BLOCKED, BROKEN, CIRCULAR, DISABLED, INVALID or NOT_SHARED. | ## 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 | | `source_sheet_id` | [[Sheets-Sheets\|Sheets.Sheets]] | `sheet_id` | In words only: Holds for a source sheet the user can see. | | `source_sheet_id`, `end_column_id` | [[Sheets-SheetColumns\|Sheets.SheetColumns]] | `sheet_id`, `column_id` | In words only: The last column of the range in the source sheet; null for whole rows. | | `source_sheet_id`, `end_row_id` | [[Sheets-SheetRows\|Sheets.SheetRows]] | `sheet_id`, `row_id` | In words only: The last row of the range in the source sheet; null for whole columns. | | `source_sheet_id`, `start_column_id` | [[Sheets-SheetColumns\|Sheets.SheetColumns]] | `sheet_id`, `column_id` | In words only: The first column of the range in the source sheet; null for whole rows. | | `source_sheet_id`, `start_row_id` | [[Sheets-SheetRows\|Sheets.SheetRows]] | `sheet_id`, `row_id` | In words only: The first row of the range in the source sheet; null for whole columns. |