Imported Hyperlink Text

Bill Kelton

We have a project management software that generates the above text representing a job location. We import the text to smartsheet though data shuttle so we can distribute dispatch information to our 300 employees. My problem is that the import works as shown above where the URL is incomplete due I'm guessing to the comma in the Google Link Text.

Any suggestions to correct this would be fantastic. I have the vendor looking at trying to generate a different hyperlink text format (similar to what Google Maps generates - those work great)

Darren Mullen

@Bill Kelton In the source sheet have the Comma (,) replaced with %2C

Or have another column in Smartsheet that replaces all Commas with %2C

Darren Mullen

@Bill Kelton In the source sheet have the Comma (,) replaced with %2C

Or have another column in Smartsheet that replaces all Commas with %2C

Bill Kelton

That works. Thank you!

Darren Mullen

@Bill Kelton you're welcome! Thanks for letting me know it worked.