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
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives