Welcome!

Pinpoint locations to a map

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

Find more posts tagged with

Community Platform

Comments

Andrée Starå

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

Thank you I will give that a try!

CherylAK

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å

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

Thank you so much! You are always so helpful.

CherylAK

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å

I'm always happy to help!

Andrée Starå

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

You're welcome!

Timothy Bugno

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

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.

akhalid

You can also embed maps using a Looker Studio Connector.

https://community.smartsheet.com/discussion/136836/unlock-the-power-of-interactive-dashboards-in-smartsheet-control-customize-and-create-with-ease

Sign in to join the conversation!

Quick Links

Trending discussions

Writing Formulas in Smartsheet - Self Paced - Optional Activity
Hello, I'm working through the writing formulas optional activity and in the 'Nested IF function - Progress Column' task it directs you to put in the following formula '=IF([% Complete]@row = 0, “Empty”)'. However, when I put this formula into the spreadsheet, '04a_Marketing Request Tracker - Formulas', I get an…
"has any of" criterea is only pulling the first item in the cell
I have an automation that has a condition where I am looking at the column "LEA Interco Supporting Site(s)" and trying to find columns that have the value "Fort Loramie" in them. This works well when "Fort Loramie" is the first item listed in the cell, but it doesn't work when "Fort Loramie" is the second or third value in…
Capturing Cost Savings by the month
Have any of you created a Smartsheet that would show the savings for a project by the month? In other words, if I saved $1200 annually and the project ended in say March, then the savings would go $120 per month, Mar 2025-Feb 2026. I have done it on Excel sheets manually, but I think there should be a way to do it with…