Google Map + Longitude & Latitude

Question

I have a column in which I am trying to join a URL and two columns, one for Long, one for Lat.  My goal is to write a formula to join them (i've tried, join, i've tried +)…. so that I can click on the link and be taking to the google map for the site.  The issue is, the first coordinate is followed by a comma and the second coordinate isn't included in the URL hyperlink.

I can COPY the value of the cell and paste it into the web browser and it works, but I want to be able to click on the link in the cell. Any thoughts?

Current formula I'm using is: =[Google Maps]# + JOIN(Longitude@row:Latitude@row, ",")

Paul Newcome · Answer

"%2C" is the encoding for a comma. Use that as your delimiter like so:

=[Google Maps]# + JOIN(Longitude@row:Latitude@row, "%2C")

Paul Perger · Answer

Got it…. This frustrated me, as I knew I had seen this done before in Smartsheet, so I went and figured it out!!

Add a column between the Longitude and the latitude and populate it with "@2C". (You could do this as a column formula to add @2C whenever there is a longitude present.)  Then your original formula will result in the following URL (and it will be clickable):

https://www.google.com/maps/search/?api=1&query=37.32696%2C-121.90147

When the link is clicked, the HTML code will interpret that %2C as a comma and your link will work!

Good Luck!

Smar Czar · Answer

Thank you, @Paul Perger - while the comma isn't required, it IS required for the sake of the URL that google maps needs.  There needs to be a comma between LONG & LAT.

I suppose ctrl + c and then ctrl C will be sufficient