Smartsheet Hyperlink to a Specific Cell in Another Smartsheet

John Crick

Greetings! Seeking this team's help with the creation of a hyperlink from one Smartsheet cell to a cell in another Smartsheet.

Attached is a brief example of what we are attempting to accomplish. Smarsheet A has a client list. Next to each client, we have the name of the price list the client is invoiced against. Smartsheet B includes all of our unique price lists.

In the Price List cells of Smartsheet A we seek the ability to click on a hyperlink that takes the user to the cell in Smartsheet B of that specific price list. So, for example, when we click on the cell for Price List 0001, we go to the cell in Smartsheet B for 0001.

Smartsheet Hyperlink.xlsx

Uploaded Mar 25, 202210.89 KB

Hopefully, this makes sense. Thanks in advance for any recommendations.

John

Sameer Karkhanis

I don't think you can hyperlink a cell but you can link to a row in another sheet. If each of your pricelist starts at a specific row in your sheet then may be row level hyperlinking could be an option.

John Crick

Sameer,

Thank you for the suggestion. That would be a helpful solution. However, I have not been successful in creating the link.

In Smartsheet A, I select the cell in which I desire the hyperlink. I right-click and select Link From Cell in Another Smartsheet. Once the link is complete with the designated row in Smartsheet B I notice that the contents in the full row of Smartsheet A now show the contents of the row in Smartsheet B. My preference is merely to have a hyperlink in the Smartsheet A cell that when double-clicked transports me to the selected row in Smartsheet B. Data from Smartsheet B should not be pulled into Smartsheet A.

Any suggestions for creating the hyperlink?

John