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 , " ", "+")
I have just recently found use cases where I needed Bridge. I created a sheet with unpivotted data. I have a love/hate relationship with the tool for now. I really like flexibility and power, what I don't like is how difficult it is to troubleshoot and in some ways manage the workflows. Seems to be some sensitive points…
raise HttpError(rex, "SSL handshake error, old CA bundle or old OpenSSL?") from rex smartsheet.exceptions.HttpError: (SSLError(MaxRetryError("HTTPSConnectionPool(host='api.smartsheet.com', port=443): Max retries exceeded with url: /2.0/sheets (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED]…
Hi Guys I have created a code which will push the latest ticket from ServiceNow Platform into Smartsheet using the Smartsheet API. I am trying to use the POST method to push the row to Smartsheet but due to some reasons it is not getting inserted even if in the activity log it keeps showing as row inserted. When I tried to…
