Using a hyperlink with a comma in?

Graham Rimell

Hi,

I'm trying to use a Vlookup to bring up a link to file when a part no is entered. Unfortunately Vlookup won't bring a hyperlink through when it matches a cell, just the cell contents. So I've created a second cell with the raw hyperlink.

However I've run into an second issue where Smartsheet won't recognise a link past a comma. It just so happens that a bunch of these links to .PDF's on Sharepoint happen to contain commas, so the hyperlink part only selects half the URL, and thus a dud hyperlink.

Is there a way to force it to recognise all of the url?

Thanks!

Mark Cronk

Hi @GrahamR ,

Try using %2C in the URL in place of the commas.

Work?

Mark