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.
Have any of you created a Smartsheet that would show the savings for a project by the month? In other words, if I saved $1200 annually and the project ended in say March, then the savings would go $120 per month, Mar 2025-Feb 2026. I have done it on Excel sheets manually, but I think there should be a way to do it with…
Hello team! Hope you all are having a wonderful holiday season. I am trying to set up an automation that will send an email reminder one time when Next Update Date = 60 days, then another automation at 30d, etc. The key is I only want it to send the reminder one time when Next Update threshold is reached. Is this possible?…
Has anyone found a workaround for sharing Smartsheet reports externally without giving access to internal data? I currently have to download the data and transfer it onto excel to create a pivot table for our client and I want to find an easier way to do so. I also already create a dashboard for our client, but I wanted…
