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

Huntb2000
Huntb2000
edited 12/09/19 in Formulas and Functions

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

  • Andrée Starå
    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

    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.

  • Andrée Starå
    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

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!