---
title: "Get cross-sheet reference"
method: GET
path: "/sheets/{sheetId}/crosssheetreferences/{crossSheetReferenceId}"
tags: ["crossSheetReferences"]
---

# Get cross-sheet reference

`GET /sheets/{sheetId}/crosssheetreferences/{crossSheetReferenceId}`

Gets the cross-sheet reference specified in the URL.

## Response `200`

CrossSheetReference object

- CrossSheetReference
  - `endColumnId` number — Defines ending edge of range when specifying one or more columns. To specify an entire column, omit the startRowId and endRowId parameters.
  - `endRowId` number — Defines ending edge of range when specifying one or more rows. To specify an entire row, omit the startColumnId and endColumnId parameters.
  - `id` number — Cross-sheet reference ID, guaranteed unique within referencing sheet.
  - `name` string — Friendly name of reference. Auto-generated unless specified in Create Cross-sheet References.
  - `startColumnId` number — Defines beginning edge of range when specifying one or more columns. To specify an entire column, omit the startRowId and endRowId parameters.
  - `startRowId` number — Defines beginning edge of range when specifying one or more rows. To specify an entire row, omit the startColumnId and endColumnId parameters.
  - `status` 'BLOCKED' | 'BROKEN' | 'CIRCULAR' | 'DISABLED' | 'INVALID/UNKNOWN' | 'NOT-SHARED' | 'OK' — Status of request: * 'BLOCKED' - A reference is downstream of a circular issue. * 'BROKEN' - The data source location (column, row or sheet) was deleted. * 'CIRCULAR' - The formula reference is self referencing and cannot be resolved. * 'DISABLED' - Updating the reference is temporarily disabled due to maintenance. * 'INVALID/UNKNOWN' - The reference is new and had not been validated. * 'NOT_SHARED' - No common shared users. * 'OK' - The reference is in a good state.
  - `sourceSheetId` number — Sheet ID of source sheet.

## Other responses

- `default` — Generic Error Payload

---

[API](https://skmtc.net/smartsheet/apis/smartsheet-openapi-reference.md) · [All operations](https://skmtc.net/smartsheet/apis/smartsheet-openapi-reference/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/smartsheet/smartsheet-openapi-reference/versions/b4afda95fb51/schema)