Cross-sheet reference maximum?
Hello! I received an error when I was working on one of my sheets that says:
"Unable to create cross-sheet reference, because this sheet already contains the maximum umber of different cross-sheet references."
This is the first time I've see it, the sheet it happened on is a dashboard metrics sheet that pulls from several different sheets different values. Is there a limit I didn't know about? What can I do to work around this?
For context, the sheet of metrics has a list of all the clinics we have (48) and each has two values that we're pulling with a formula (=value and =countif) from it's respective sheet.
Answers
-
Hi
The limit is 100. So if you have 48x2 you would be very close to that limit. You may have a couple that you are not using (right click and select Manage References). Deleting those that aren't in use could unblock things for now but won't allow any wiggle room to add any more data or clinics in the future.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.2K Get Help
- 358 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 135 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!