I am trying to add a hyperlink to an address in a cell that can take me to a pin in a Google map.
How do I add the cell value that contains the address in the hyperlink so that, when clicked, it will take me to that address in the Google map vs. just an opening page which shows my current location? I have hundreds of cells with different addresses which I would like to add hyperlinks to so adding each address with it's own link is not an option.
Answers
-
Hi @veydelman
Smartsheet will not auto convert an address to a link in Google Maps.
You can type the address in Google Maps and copy the URL from the address bar of your browser from the result page. In Smartsheet, you can right click on the cell and click on "Hyperlink". You can then paste the copied Google Maps coordinates in the URL section and in the display text, you can add the address as below.
Thanks,
Aravind GP| Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.2K Get Help
- 359 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 135 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives