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.

Columns

I would like to be able to link columns from one sheet to another.

 

Thank You

Comments

  • JohnHinkle
    JohnHinkle ✭✭✭✭✭✭

    Use cell linking. While you cant link an entire column, you can link all the cells in a column: http://help.smartsheet.com/customer/en/portal/articles/861579-cell-linking

  • I found a way to do what I think you want.

     

     Click on topmost cell in the column you want to link to, then drag bottom right corner down to how many columns you want to link (like 50) and they "highlight", click link button on tool bar.

    then go to sheet you want to link from and do the same procedure (highlight 50)

    Click "Create Link" bottom right.

     

    Hope this makes sense, but I did it on one of my sheets several times.

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    Alan,

     

    You can skip the first selection. Just right-click on the top cell you want to link to, not the whole selection. Select the Create Link menu item.

    In the "Link from Cell in Other Sheet", do you your selection as you describe.

    When you click "Create Link", it will fill in the column below. You don't need to worry about matching up the number of cells selected in each sheet.

     

    Hope that was clear and helps.

     

    Craig

     

  • Angie Hatfield
    Angie Hatfield ✭✭✭✭

    Can you do this with blank cells so the data auto-fills when entered on the source sheet? My source sheets are over 1300 rows and growing., is there any way to work around the 500 cell limit when linking cells instead?

     

    Thank you

  • Angie, the 500 cell limit is just per action. You can have up to 5000 inbound cell links in a a sheet.

     

    You can cell link blank cells if they had contained data at one point. So, add data to your cells, save your sheet, then delete the data. Now you can cell link these blank cells. 

  • Angie Hatfield
    Angie Hatfield ✭✭✭✭

    Thank you for the info about the blank cells. That will be helpful.

     

     

This discussion has been closed.