Pinpoint locations to a map

CherylAK · 08/22/19

Is there any way to extract an address from a sheet and pin it to a map? I would want to pin several locations to the same map if possible.

I was thinking maybe somehow do this in a dashboard??

Thank you,

Cheryl

Andrée Starå · 08/22/19

Hi Cheryl,

Yes, with the Smartsheet Lab - Smartsheet Maps addon.

More info: https://help.smartsheet.com/articles/1456243-smartsheet-labs

Would that work?

Another option could maybe be Google Maps.

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

CherylAK · 08/22/19

Thank you I will give that a try!

CherylAK · 08/22/19

How do I get that to post in a dashboard? I tried to link it, but it says it's an invalid url.

Thanks again!

Andrée Starå · 08/22/19

I missed the part with the Dashboard.

Unfortunately, it's not possible at the moment, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

It sounds like Google Maps would be a better solution for your need.

Google Maps

Please use the steps in the "Embed a map or directions" section of the Share a map or directions with others Google help article.

Google My Maps

Visit the Google My Map that you want to embed. 
Click the three dot menu that is next to the Map title. 
Click Embed on my site .
Copy the embed code and paste it into the Web Content widget field .

CherylAK · 08/22/19

Thank you so much! You are always so helpful.

CherylAK · 08/22/19

Just so you know the Smartsheet mapping app worked like a charm. I hope they finalize it soon. I will send in the suggestion about the dashboard link.

We are tracking fatal/non fatal drug overdoses. The address, date, and whether or not it was fatal makes up my sheet. So I made a map to collect the addresses and whether or not it was fatal or non fatal at that address. It populated and also had different color markers for fatal and non fatal. I believe though that it will only do that for 12 addresses...not sure.

Thanks again,

Cheryl

Andrée Starå · 08/22/19

I'm always happy to help!

Andrée Starå · 08/22/19

Glad to hear it works well and especially when it's for something as important!

You're welcome!

Timothy Bugno · 10/06/20

It looks like that Dev site isn't accepting new testers. Do you know how close the mapping feature is to being finalized (or is it finalized)?

bca · 08/29/22

This might be worth a look. https://www.smartsheet.com/marketplace/apps/mapsly-interactive-map-smartsheet

Would be interested in what you end up doing if you’d like to comment back here? I’m looking to do something similar.

Pinpoint locations to a map

Comments

Google Maps

Google My Maps

Categories