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.
Howdy, I am working on developing a several dashboards for our team, and for whatever reason the widgets I place are multiplying. I have copied/pasted some, but other I have just added I am ending up with dashboards that look like this: When originally I only had the top four items. It has happened on several different…
I am a construction project manager and built sheets that include actual costs for individual tasks, departments and overall project. I update the costs cells as invoices come in by manually calculating then entering in new amount. Ex: Plumbing: week 1 $300, week 2 $250, week 3 $150 = $700. I enter $700 in cell. I'm…
I have multiple items that each have their own statuses and that roll up to "workstreams" or swimlanes. On the dashboard, I would like to show the progress of the items by swimlane without breaking it out into separate widgets for each. This would ideally be a stacked bar where each bar represented the Items and was broken…