Link count and Ranges - Does each column in a range count as a link?

Huntb2000

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?

 

Andrée Starå

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

Andrée Starå

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