Reference another sheet's cells from a formula and the engine resolves it, recomputing when the source changes. Same project: type [Sheet]!A1 (and ranges like [Sheet]!A1:B10 or whole columns [Sheet]!A:A).
Cross-project works too: [Project][Sheet]!A1 binds to a sheet in another project, gated by access. You can only bind a reference to a sheet you have read access to; resolve returns 'not found or no access' otherwise (no existence leak), and a viewer who can't read the source sheet sees the value's absence, never the hidden data.
Typing [ opens a typeahead that suggests sheet names as you go (across every project you can read) so you don't copy names by hand. Pick one and it inserts the bracketed reference for you. No 'Manage References' modal. Per-sheet limit: 200 cross-sheet refs on Pro, 500 on Business.
Activity
- Ryan K. opened this entryMay 27, 2026
- ShippedMay 27, 2026
The Smartsheet 'Manage References' modal was a non-starter, so this is plain in-formula syntax: [Sheet]!A1 same-project, [Project][Sheet]!A1 across projects. Access is the boundary, not the project line. You can only bind to a sheet you can read.
Shipped, including cross-project. Reference any sheet you can read and the engine resolves it and recomputes when the source changes. Typing [ pops up sheet-name autocomplete that spans projects. ACL-enforced end to end: no read access, no bind ('not found or no access'), and viewers without access to the source see the value's absence, not the data.