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
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
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!
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.
Please use the steps in the "Embed a map or directions" section of the Share a map or directions with others Google help article.
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,
I'm always happy to help!
Glad to hear it works well and especially when it's for something as important!
You're welcome!
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)?
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.
You can also embed maps using a Looker Studio Connector.
Hi everyone, My boss is bringing data in from my Smartsheets into PBI. He is having issues with the dollar value columns showing up as text instead of dollars. There is no option for the column except for text/number. What can I do to solve this problem? Thanks! Freda
How do I make a dashboard available so that anyone can access it without having to login?
I have a project tracking sheet that is updated weekly with the most recent updates for project progress, issues/concerns, barriers requiring intervention and next steps. How can I display only the most recent updates for these 4 columns in a dashboard?
