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
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
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 33 Webinars
- 7.3K Forum Archives