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
Check out the Formula Handbook template!