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?

Find more posts tagged with

Formulas

Cell linking

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

Calculate Project Time TOTAL for PM across aligned projects
Hi - I am trying to figure out how to create a SUM of the Total Project Time aligned to each PM for all of their projects. On my master sheet I have the Resource Type, Resource Name, and a Helper Column for Time. The Helper Time is an estimated allotted time based on the timeframe of the project. Example: <3 months = 25…
How to Create Time Duration
I have a report where I need a formula to figure out time duration. For example, employee starts at 8:00 am and ends at 9:00 am, I need the next column to tell me 1.00 to indicate he worked 1 hour. I will be using military time throughout this sheet.
Formula with range data
Hello, I'm looking to see if anyone knows a formula that would add owner income and co-owner income together to reflect in Joint Income column. I'm not sure how to do this with data in ranges. Thank you.