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
-
@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, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Answers
-
@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, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
That works. Thank you!
-
@Bill Kelton you're welcome! Thanks for letting me know it worked.
Darren Mullen, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!