Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
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?
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
instead of
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!
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
Wanted to check in on this myself - have you had any luck with the links?
thank you
Hello, I am looking for a formula that returns data if columns match in two different sheets I want to return the Trailer Number to sheet 1 from sheet 2 Sheet 1, Truck Tracker: Has column "Location" to match with the same column in Sheet 2. I want to return the Data from Column "Truck Number" (on sheet 2) to Column "Truck…
Currently, there is a form linked to a Smartsheet that automatically updates every time the form is submitted. I need to graph data from specific columns, which I want to be in another sheet for visual clarity. From what I understand, I need to pull that data into the sheet I am charting in before I can plot it. What…
Hi all, I have a sheet "Transition Tracker" where my team adds data that can often change throughout the lifecycle of a project. When this data is initially added, I have an automation that copies it to another sheet used by another department. I need to add a formula to the other department's sheet that will update a…
