-
Update Request Hyperlinks
This is a standalone of a request I've seen pieces of in other threads. I would like to see URL's that are included in the message of an Update Request be clickable when the Update Request has been opened. As it is, the email notifying the user of an update request has a clickable URL hyperlink, but when they open the…
-
Formula to create link to filtered report using data from originating sheet as the "filter"?
I'm trying to create a master sheet that will be used as an onboarding checklist for new sales orders. There is quite a bit of leg work to do prior to the job starting and we need to track the steps and whether they are complete or not. I was thinking I could have the master sheet contain all of the check lists with a…
-
Import Hyperlinks via Formula (not via Cell Linking)
Hello, Hyperlinks do not import when I use a formula (e.g. INDEX/MATCH, or INDEX/COLLECT) to locate & import a targeted cell. The text in the indexed cell is imported, but not the hyperlink. I am aware of Cell Linking, which does import the hyperlink. But it is burdensome to apply Cell Linking to all the cells in my sheet.…
-
Best Practice for Control Center managed links in project templates
When we developed our templates with the Smartsheet rep years ago, they mentioned it was important to keep certain 'metadata' in the second column, and that there should not be another column between the primary and second column. Below is an example of the navigation section and the summary section at the top of our WBS…
-
Creating a Hyperlink in the Send as Attachment Email
I have created a schedule to send my sheet to individuals each week (see above), but would love to include a hyperlink to the sheet in my email. I know hyperlinks are included if I create a workflow for this, but can I add a hyperlink if sending this way as well?
-
Syncing links between Smartsheet and Salesforce
I use the Salesforce Connector to synchronize information between Smartsheet and Salesforce. One of the fields we want to show in Salesforce contains a link to a project dashboard in Smartsheet. The cell with the link normally contains the project name hyperlinked to the dashboard. However, the connector will only copy the…
-
URLs for Templates
I have a few sheets that I saved as templates for other team members to use. I wanted to make the templates accessible from a dashboard by adding a shortcut to take users directly to the template preview so they can view it and choose to use the template.
-
Remove/Delete existing hyperlink using API
Per the problem outlined in the below community post, it appears the API is unable to remove existing hyperlinks from cells. It is possible to add or update hyperlinks, but not delete/remove them. Please add the ability to either completely clear cells (including hyperlinks) or remove just existing hyperlinks using the…
-
Form Validation for Hyperlinks
Add validation for hyperlinks to forms in order to prevent users from submitting form with text in a field asking for hyperlinks only. Users frequently type "none", "NA" or ask questions in the hyperlink field despite clear field labeling, help text and training. Having the ability to validate if the data entered was a…
-
Hyperlink to corresponding row in external document
I have a 600 row Smartsheet and need to provide hyperlinks for each row to an external Excel document. At the moment, a basic hyperlink will open Excel but place the cursor at the top of the sheet. Can I create a hyperlink formula to match the reference numbers on each row? Link for Reference 010 opens Excel document with…
