Sign in to join the conversation:
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.
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…
I have a picture below for an example of this. I want to create a formula to get counts of items in "Column2", but if "Column4" states "change" I want the "Column2" count to not work and instead count what is it "Column3" in that given row. Column4 can also have several different things in it besides "good" that I want it…
I've done this a million times - create a report, separated by campus with a total $$. Then add it to a dashboard and make a graph. NOTHING is working right now when I try to do this. I get an error that the data cannot be charted. What the what? Help anyone? Is this a issue since they apparently changed something in the…
