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 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 Builders, You’ve been asking versions of the same question in this community: when do I use Smart Assist, when an automation, when MCP, and when plain API code? 🤔 So we’re starting a new series, the Smartsheet Builders Series: Building with Smartsheet MCP and Agents, and the first post tackles exactly that. 📖 Smart…
I know I can manually configure a dropdown column in Table View so that its options are linked to a column in another sheet. This is useful because the dropdown values can be maintained in one source/config sheet. However, I have around 100 existing sheets where I need to configure the same linked dropdown setup. I would…
Thank you to everyone who joined us for our first session on the Smartsheet MCP. You came with sharp questions and curious energy so it was a great reminder of why this community exists: to figure things out together. A big thank you to Ivan Ivano and our staff engineers for bringing the answers! Missed something or…
