Sign in to join the conversation:
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?
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?
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.
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.
What has happening to the Share a sheet option - I only have share a Workspace - and it doesn't offer the option to share a sheet - and i cant find where to unshare a sheet either - currently to share a sheet we have to send a link and get the user to request access to the sheet - but there doesnt appear to be away to…
@Paul Newcome , Hope you are well. Question for you, meant to ask quite some time ago but forgot. You had shared this right after Engage 2025. I'm unfamiliar with the view and how to create it. Can you tell me about this view?
I am trying to change owner on a Smartsheet sheet to the owner of the workspace it is located in. I keep getting an error message stating the permissions need to be managed at the workspace level. I am unable to change owner for the sheet at the workspace level. Not sure how to accomplish this change. HELP!