Cross-sheet reference limit clarifications
Dan Seidler
✭✭
We have a couple cross-sheet reference questions:
- Where can we see how close we are to the 25,000 cross-sheet reference and 5,000 cell-link limits? Also, is there a go-to link to these references?
- Clarification please: We have one Master Sheet and 3 other sheets that refer (pulls data from) the Master. Does the cross-sheet references limit of 25,000 cells refer to the number of times our supporting sheets refer back to (pulls data from) the Master? Or is it the other way around (i.e. the # of times the supporting sheets are referred to by the Master)?
- What about the above scenario (#2), as it relates to “A total of 100 distinct cross-sheet references can be created on a sheet.”
Thanks,
Dan
Tags:
Comments
-
Hi Dan,
I'll answer your questions in the order that they were delivered:
- The exact number of references and cell links being used currently isn't automatically displayed somewhere; however, you will receive a message when trying to link or reference cells over this limit.
- The 25,000 reference limitation is per sheet, meaning a single sheet can reference up to 25,000 cells from any combination of other sheets.
- You can create up to 100 cross-sheet references per sheet (references in the curly brackets) that can, combined, reference up to 25,000 cells. Meaning you can create up to 100 uniquely named references that reference 250 cells apiece—per sheet.
-
Hi Shaine,
I appreciate the clarifications.
Thanks,Dan
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives