Hyperlink to corresponding row in external document

Options
22Wordsmith
22Wordsmith ✭✭✭
edited 04/30/24 in Formulas and Functions

I have a 600 row Smartsheet and need to provide hyperlinks for each row to an external Excel document. At the moment, a basic hyperlink will open Excel but place the cursor at the top of the sheet. Can I create a hyperlink formula to match the reference numbers on each row?

Link for Reference 010 opens Excel document with cursor at Reference 010.

I tried to insert a Reference@Row but it came back as UNPARSEABLE. This is the formula I tried to use:

=Hyperlink("PATH to MY DATA",{Reference@row})

Grateful for any guidance.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!