Sign in to join the conversation:
I know that the smartsheet charts app is still in production, but is it possible to have sheet containing North American states and hyperlinks, then using the 'map' chart, click on a particular state and then it will take you to that hyperlink?
Hi Dwayne,
The Maps labs app is separate from our Smartsheet charting functionality. (We do have a separate Chart labs app that uses Google charts, which will soon be discontinued.)
With the Maps labs app, you can manually add locations to your sheet and have the Maps app create map pins based off of this. More info on this app is available here: https://www.smartsheet.com/apps/smartsheet-maps
I would like a way to open Google Maps and route me to an address when selected from my Smart Sheets mobile app. Similar to calling or email. Suggestions would be great. Thanks
@Shaine Greenwood Can you please fix the link to the Maps App above. I've spent about 90 minutes trying to get a simple google maps link based on lat/long working and I'm hoping this can help. Currently I only see mapping links working as expected if you fill a form from the smartphone app. Seems odd to only have that functionality on mobile.
Any help appreciated.
thanks,
Eric
I would agree/2nd this. It is months after Shaine's comment above, and the link is still broken...
Thanks!
I suggest trying Mapsly which is an extension available on Smartsheet Marketplace. Within that tool you can display your records from Smartsheet and show them as points on the map and quickly filter points by state/city. Inside the map you can click to go back to Smartsheet to that record (row).
Type the address on google maps, click share location. Hyperlink to specific cell in smartsheet “cntrl v”.
For anyone who stumbles upon this post looking for a simple way for addresses in a Smartsheet to open in Google Maps when you click them what I did was create a new column and called it MAP IT!. In the first cell in the column I pasted the following and then converted it to a formula. In my case I have a column called Address with the street address and a column called City State. This formula combines the values from both into a link that opens in Google Maps.
="https://www.google.com/maps/search/?api=1&query=" + SUBSTITUTE(Address@row, " ", "+") + SUBSTITUTE([City State]@row, " ", "+")
I know this is kind of sloppy but after days of searching, thanks to cbsarge I was able to take what he posted and figure out how to adapt it to my own sheet to make it work.
my sheet looks like this. I need to be able to map the address in the JOB ADDRESS column so my formulua for Map it column is
="https://www.google.com/maps/search/?api=1&query=" + SUBSTITUTE([Job Address]@row , " ", "+")
Hi - my organization has been using Smartsheet for several years and we're looking to automate wherever possible for consistency and efficiency. Whenever a new project starts, the PMO creates a timeline (save as new) from a template that's specific for that project type. The PMO manually updates the default value in a few…
I know this is a problem with EU region as well, but wanted to know when regions other than north america will get support for apps like zapier. Everywhere I have read it is always the app developers saying they are waiting on smartsheets. I have tried cloning the connection app on the websites like zapier and maker and…
I've a sheets where the columns names are the following (without the quotes) : "Expiration Date " "Expiration Date " So, the first one has a space at the end and the second one hasn't. Previously that was supported by smartsheet API AND the user interface, although it's not possible anymore. What's funny : Most features on…
