-
Merged: Hyperlink transfer with VLOOKUP or INDEX(COLLECT)
This discussion has been merged.
-
Hyperlink support in Index/Match/Collect/etc. functions
As other posts for help point out hyperlinks do not transfer when when using functions to look up hyperlink values. Please add support for looking up hyperlink values via formula such that the Display Text and URL transfer to the destination. See details in the links below. The workaround of linking to a cell in another…
-
Hyperlinks in sheet - Sheet embedded in a Dashboard - not appearing.
I have a source sheet that contains hyperlinks to reports. The source sheet is published as "Read Only - Full" The published sheet is embedded in a dashboard as a "Web Content Widget". None of the Hyperlinks are visible in the dashboard. When selecting the cell it displays cell info as shown below - The "Sheet" link has no…
-
How do we get our hyperlinks to work properly?
We are currently working on a sheet where if a specific number is entered in a cell, a corresponding hyperlink will be next to it. We have a sheet for hyperlinks and the IDs that are associated with them so that we can use a formula to pull that link when it sees its code. Our issue is that even though our links are…
-
Row Reminder Email with Link
It would be much more convenient if there was a link to the sheet in the email received from a Row Reminder, like there is from an Automation email.
-
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?
