Welcome!

GPS location

I really like the GPS location that seems to be enabled in the Asset Location template for example. I have about 1000 locations for street furniture we want to upgrade. So we already have the locations in an Excel sheet. How could we transfer those locations in Excel to a GPS location that can be clicked such as the one in the template?

Find more posts tagged with

Comments

Etienne Portelance

OK, I got part of it OK

I created a colunm concatenating the lat and long I have in two other columns and put the following text in a cell:

="https://www.google.com/maps/search/?api=1&query="+lat2+","+long2

That would work except that the comma seems to stop the hyperlink continuing.

The link once clicked is missing the longitude

https://www.google.com/maps/search/?api=1&query=45.49538

instead of

https://www.google.com/maps/search/?api=1&query=45.49538,-73.61981

Andrée Starå

Hi Etienne,

Interesting!

I’ve developed something similar for a client to create a URL to search for packages.

I’d be happy to take a look and see if I can help!

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

eric.meyer81346

Hi Etienne, Did you ever get the lat/long hyperlink to work?

I would like to do the same thing to build a mapping link.

thanks,

Eric

MichaelB

Wanted to check in on this myself - have you had any luck with the links?

thank you

Sign in to join the conversation!

Quick Links

Trending discussions

Week Number Year to Year
I've got the following formula in a Check Box column to check when something is due in the Next 3 weeks. =IFERROR(IF(AND(WEEKNUMBER([Projected Cleaning Date]@row ) = WEEKNUMBER(TODAY()) + 3, YEAR([Projected Cleaning Date]@row ) = YEAR(TODAY())), 1), "") I have them for 2 weeks, 3 weeks, 4 weeks, and 5 weeks. These stopped…
Use Sheet Summary as cell reference for a different sheet
I'm using salesforce connector to pull my team's hours information in real-time. The Salesforce connector sheet contains sheet summaries that I'd like to use a cell reference for a different sheet. I can't seem to find the best way or formula to do this. I don't want to use a dashboard with report widgets because I prefer…
Issues with IF formula
I have two formulas which work well independently, but when I combine them they don't. formula 1: =IF(YEAR([Joined date]@row ) = 2025, JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritisation Survey 2025 - Org}, [Organisation name]@row ))) formula 2: =IF(YEAR([Joined date]@row ) < 2025,…