Smartsheet Hyperlink to a Specific Cell in Another Smartsheet

Options

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.

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


John

Tags:

Answers

  • Sameer Karkhanis
    Sameer Karkhanis ✭✭✭✭✭✭
    Options

    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
    John Crick ✭✭✭
    Options

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!