Link count and Ranges - Does each column in a range count as a link?
Hi Folks,
After reading up on the issue of cross sheet link limits, I would like to confirm what 'counts'.
If a range is defined as having 10 columns does that count at 1 link or 10?
If a range has 20 columns is that 20 links or one?
And finally if that same range is used for several VLOOKUP functions in a destination sheet, does each use of the VLOOKUP (with a different return column number) count as a link?
Comments
-
Hi,
Smartsheet always counts a range as one cross-sheet reference of the 100 available for each sheet.
If you're using the same range multiple times it still only counts as one reference.
Hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
More info:
Before You Begin
Here are some things to keep in mind as you work with cross-sheet formulas:
- All the data in the range being referenced is available and potentially visible in the destination sheet, meaning you shouldn’t include any data in the reference that you don’t want available in the destination sheet.
- Each sheet can include no more than 100 distinct cross-sheet references.
- There’s a limit of 25,000 inbound cells that can be referenced from other sheets into one sheet in total.
- When you create a reference to another sheet, you can only reference data from a single sheet. If you need to reference data from multiple sheets, you’ll need to create multiple references using the steps below
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!