What is Sheet Referencing?
Sheet Referencing syncs one sheet with another so they share filters, timeline, rows, columns, sort rules, and row templates. This saves setup time and keeps similar sheets aligned — change the source once and all referencing sheets update.
It also works in dashboard tiles, though only against real sheets (not other sheet tiles).
Enabling referencing
Open Sheet Options in the sheet toolbar and choose Reference another sheet. Select the source sheet, then pick which aspects you want to sync.
When you first reference a source sheet, the new sheet seeds its filters and timeline from the source even if you don't enable the "Use its filters" or "Use its timeline" toggles. That way you start from the same view the source has, then drift from it independently if you want.
Once referencing is set up, the source sheet's name appears as a link in the referencing sheet's options — click it to jump straight to the source.
Referencing options
Use its filters: Use the referenced sheet's filter setup.
Use its timeline: Sync the timeline selection.
Use its rows: Use the same row structure.
Use its columns: Use the same custom columns.
Use its sort: Sync sort rules from the source. Local sort editing is disabled while enabled.
Use its templates: Sync row templates from the source. The template editing modal is hidden while enabled — and also hidden for view-only / data-edit users regardless of referencing.
When an option is enabled, the current sheet becomes locked for that configuration — you can't override it locally. Disable the toggle to unlock and edit it independently again.
Example
If Sheet B references Sheet A:
Changing the filter on Sheet A and saving will update Sheet B.
Disabling "Use its rows" resets Sheet B to a blank row structure.
Disabling "Use its columns" removes custom columns inherited from Sheet A.
Toggling "Use its sort" hands sort control back to Sheet B locally.
Toggling "Use its templates" re-enables the template editing modal on Sheet B.
Entry Links
Sheets opened through entry links (shareable URLs that point at a specific sheet view) also support the standard sheet config — including a Reset config button that reverts to the saved default when one exists. Useful when the entry-link landing page has drifted from how it was meant to be presented.
Referencing in dashboard tiles
Sheet Referencing works the same way inside dashboard sheet tiles — the same toggles are available in the tile's sheet options. One restriction applies: you can only reference real sheets, not sheet tiles from other dashboards.
📹 Feature Spotlight: Sheet Referencing
Want a visual walkthrough?
Watch how Sheet Referencing lets you build one template sheet and instantly sync its rows, filters, timeline, and columns across all related sheets — saving hours of repetitive updates.