Retaining Hyperlink in linked cell?

Mikehud83

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

Mikehud83

Many thanks, Brent! That worked.

Brent Wilson

@Mikehud83

Before I reinvent the wheel have a look at @Genevieve P.'s explanation

https://community.smartsheet.com/discussion/86714/hyperlink-function

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.

Mikehud83

Many thanks, Brent! That worked.