Imported Hyperlink Text

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)

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!