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 have a workflow where, when a team member checks a checkbox, Smartsheet automatically sends an email to themselves containing merge fields that are used as a customer email draft. The challenge is that this activity typically happens on a deadline day, and a team member may need to generate 30 or more of these…
Hi all, reaching out to see if of you have ideas; I'm hoping this makes sense: I'm having some trouble getting my formulas to pull data in correctly. I currently have a sheet (primary data) where I have data in rows where each row is a single project, with columns identifying persons, $ values, unique project identifier,…
I have #'s that pull from each project into each sheet's - sheet summary. Those then get pulled into a sheet summary report. They are currently grouped by what channel they are in. Each column gives a total sum. I was asked to see if we can combine the total sum into one number, so it shows how many total SKU's are being…
