Ability to dynamically link sheets
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
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives