Hyperlink from a report

DonldS82826
edited 12/09/19 in Smartsheet Basics

I have a report from a smart sheet. I want to have a hyperlink to be able to open the data sheet from the report, but the data sheet is not listed as a sheet when you open the hyperlink to another sheet.

Why can I not see it?

Smart Sheet - Hyperlink Issue.jpg

Comments

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    It looks like you're trying to link to a sheet. You can use the URL method to link to the report directly. Could the sheet exist in a different folder or not be in that folder structure? 

  • DonldS82826
    edited 04/18/19

    I created the folder to make sure that the report and the sheet were in the same place, thinking that that would solve my issue, but it did not.

    I want to hyperlink the sheet from the report so that you can "drill down" to see the raw data.

    Smart Sheet - Hyperlink issue 2.jpg

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    You cannot use the Hyperlink to another SS function like that to link to the sheet you are currently on. You can however copy/paste the URL of the sheet into the "Link to URL:" box and enter the sheet name in the "Display Text" box.

     

    You can also include the Sheet Name column when in the Report Builder. This column will contain a hyperlink directly to whatever sheet the data is coming from.