Cell Linking | Smartsheet Learning Center
https://help.smartsheet.com/learning-track/level-2-intermediate-users/cell-linkingCell link data between sheets for real-time updates.
Ability to dynamically link sheets
bsmith4
✭✭
Hello, I am guessing that this question will require coding and the API but I'll ask anyway...
Is it possible to look up the name of another sheet on a row and then identify cells in that sheet by name or position and then link to the data? Please note that I do not want a =vlookup in the receiving cell, I want to end up with a link to a specific cell in the sheet to which I am subscribing.
I recognize cells can only have one function, either linking or a formula but not both so I am prety sure this would require API work.
Regards,
Brian
Answers
-
Hello Brian,
You do not need an API for this or coding, but you will need a hyperlink or a formula.
You can do this link several ways, two are below.
Link a specific cel using Cel Linking:
-or-
Select a sheet and target range and put it in a Cross-sheet formula:
-
Hello Seth, I am well-versed with these concepts you mentioned above. However, I am looking for a way to look up another sheet name on a row, gain access to that sheet to update specific cells in it using automation.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.6K Get Help
- 435 Global Discussions
- 152 Industry Talk
- 495 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Trending in API & Developers
- We have setup a Power Automate RPA on a dedicated PC to run a series of repetitive steps which are triggered by a new row of data entering one of our smartsheets. The RPA has its own login credentials…
- I'd like to be able to collaborate or even open to purchasing of SDK for PHP. Although PHP is not directly supported, one of us has to take an initiative, and wondering if anybody has a starting point…
- I've been trying to figure out how to configure Kofax's Call REST Web Service step so I can use an API to attach local PDFs to specific rows of a Smartsheet. I keep hitting dead ends or examples for e…