Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Link to cells in a different sheet

Options
Declan
Declan
edited 12/09/19 in Archived 2017 Posts

Hi SC,

I need to link cells across two different sheets and I am looking for a way to avoid having to create the link one by one. The  cells to be linked are located in adjacent columns so ideally, I would just need to create the first link for the first column and then drag the formula through all the columns.

I tried it, but when I drag the formula, Smartsheet copies the value, not the formula with the link.

Thanks in advance for your help 

Comments

  • Schiff A.
    Schiff A. Employee
    Options

    Hello,

     

    For creating multiple cell links at one time, you have a couple of options:

    1. When creating inbound cell links can link multiple cells at once by shift-clicking the start and end of a range or by ctrl-clicking multiple cells.  This works best when you have a contiguous horizontal range of cells in a source sheet that will be linked to a contiguous horizontal range of cells in the destination sheet. 

     

    For more information, see this article: https://help.smartsheet.com/articles/861579-cell-linking#create

     

    2. If this is an action you need to take frequently or based on a lookup table, our DataMesh premium app may be a good solution for you.  DataMesh allows you to automatically copy or cell link in data based on lookup values. For more information, contact our sales team here: www.smartsheet.com/contact

This discussion has been closed.