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

Seth Morth

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:

Cell Linking | Smartsheet Learning Center

https://help.smartsheet.com/learning-track/level-2-intermediate-users/cell-linking

Cell link data between sheets for real-time updates.

-or-

Select a sheet and target range and put it in a Cross-sheet formula:

Cross-sheet formulas | Smartsheet Learning Center

https://help.smartsheet.com/learning-track/level-3-advanced-users/cross-sheet-formulas

Build formulas across sheets for a roll-up aggregation.

bsmith4

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.