How do we get our hyperlinks to work properly?

Leahbartsch

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 working properly in the link sheet, when our main sheet pulls it, only about half the link works and the rest turns grey. Please see the attached example.

Adam Murphy

That looks like a comma in the url, which would not be allowed. The source sheet has a typo in the Display Text for the hyperlink (which is what is actually being returned, not the underlying URL…this is why it works when you click it in the source sheet). That's my guess.

Leahbartsch

Yes, we figured it was the comma. Unfortunately, that's the way the link is displayed when copied directly from the site. Also, we attempted to change the display text in Smartsheet, however, the link still doesn't work.