Using a hyperlink with a comma in?


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?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!