-
Link to Dashboard on Sheets
Hello! I'm trying to figure out if there is a way to have a column on a sheet populate a link to a dashboard if the primary column is not blank. I know how to insert a hyperlink to the Smartsheet Dashboard, but it appears that cannot be converted to a column formula. I've tried creating the link as a Summary Field or on a…
-
automatically add a URL prefix to text entered into a cell
Hello! I have a sheet where my team members enter a ticket number into a column and then we hyperlink those ticket numbers to an external URL. In every case, the URL associated with a ticket number is the same, with exception to the final characters which are always the unquire corresponding ticket number. Is there a way…
-
Populate a Form Field depending on a URL
Hi, I'm not sure if this is possible. We have a website with a list of all our technical documentation. There was an idea, to have a link next to each document, where if they click on that link it will take them to our Smartsheet form to suggest a change. We have a generic form at the moment, with a dropdown list of "some"…
-
Merged: Hyperlink Partial Cell Text (not all cell text)
This discussion has been merged.
-
How do I extract full URL from Hyperlink cell?
Hi all I have this Opportunity ID column in my sheet that's connected to Salesforce. All cells are hyperlinked with the opportunity in Salesforce. This column is created like this by the Salesforce-Smartsheet connector and it's handy because of the hyperlink. I need to send the Salesforce URL to another sheet, but if I…
-
Open Sheet in New Tab When Select Hyperlink in Report
I would like to be able to open my linked sheet in a new window when I select the hyperlink from a report. I have very lengthy reports that pull in hundreds of sheets. When reviewing data, I'll expand and collapse grouped data as I work my way down the report. I occassionally need to navigate to the underlying sheet to…
-
Submitting a hyperlink in a form
Hello, I've created a form that collects news article submissions from my staff. I have a field where you can paste a hyperlink to the article, but I'm wondering if there is any way to have a field for the hyperlink and a different field for the text that displays for the link. Much the way you can add a hyperlink directly…
-
Duplicate Values For Columns with Hyperlinked Values
I've found a formula to indicate whether there's a duplicate value in a column, which is great. However, it appears Smartsheet does not recognize any cells that are hyperlinked so the formula treats this as a negative, even if the values are identical. I've noticed other issues related to hyperlinked cell values like when…
-
The Link is not working
Hi, we have a master portfolio summary sheet, it takes data from different sheets. There are two lines strangely doesn't show the linked Data, even though it shows it is correctly linked. I tried to remove the link and link again, still not showing anything. I am not sure how to fix this.
-
Datasheet reference URL
I have a column with the link to another datasheet, how can I write the full URL into another column?