What is Sheet Referencing?
Sheet Referencing syncs one sheet with another so they share filters, timeline, rows, and columns. 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.
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.
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.
Referencing in dashboard tiles
Sheet Referencing works the same way inside dashboard sheet tiles — the same four 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.