Pinpoint locations to a map

CherylAKCherylAK
edited 12/09/19 in Using Smartsheet
08/22/19 Edited 12/09/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

Comments

  • Andrée Starå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

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Thank you I will give that a try!

  • 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å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

    1. Visit the Google My Map that you want to embed.

    2. Click the three dot menu that is next to the Map title.

    3. Click Embed on my site
.
    4. Copy the embed code and paste it into the Web Content widget field
.

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Thank you so much!  You are always so helpful.  :)

  • 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åAndrée Starå ✭✭✭✭✭

    I'm always happy to help! laugh

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

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

    You're welcome!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • 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)?

Sign In or Register to comment.