Retaining Hyperlink in linked cell?
I have created a "database" of site, client, and related information in one of my Smartsheets. For the site address, I am creating a hyperlink to a Google Maps page. In a second Smartsheet I am linking to this "database," but the address comes through just as text, not a hyperlink. Is there a way for the second sheet to retain the hyperlink?
Thanks for any light you can shed on this.
Mike Hudnall
Best Answer
-
Many thanks, Brent! That worked.
Answers
-
Before I reinvent the wheel have a look at @Genevieve P.'s explanation
Her explanation is
A cross-sheet formula bringing in a hyperlinked cell will only be able to pull in the Display Value, or the front end text, and not the URL behind the text as well.
However, if you store the link on your reference sheet as the full URL, this will come through the VLOOKUP as a URL that can be clicked on as well
Don't know if that steers you in the right direction.
Brent C. Wilson, P.Eng, PMP, Prince2
Facilityy Professional Services Inc.
http://www.facilityy.com
-
Many thanks, Brent! That worked.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 283 Events
- 33 Webinars
- 7.3K Forum Archives