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.
Hi all, I have a form where people request a guide be created. Once that submission is complete, I have to take several of those data points and create a workflow template. Is there any way to take the data from a row and map it to the template to create the client specific sheet automatically? I am thinking of something…
I have a Portfolio Dashboard, In tht we have multiple domains and each domains have multiple projects. I have created a main Dashboard which is having a link of Portfolio and each domain overview dashboard. I have individual project Dashboard also Now in each domain Dashboard i want to include a project selector and as…
I have a dashboard series of reports that have the sum of all room populations for the specified spaces in the report summary. Is there a way to capture the summary from these reports? I want to have a text box that displays these sums… I am trying to avoid having to setup yet another helper column to count up these spaces.
