Map On Smartsheet Dashboard - Overlay With Locations and Data - How To Instructions

Ryan Sides

How to Add an Interactive Map to Your Smartsheet Dashboard

The Challenge

One of my Smartsheet consulting clients recently asked how we might be able to accomplish this.

They have projects at multiple locations across the US and wanted to see them on an overall dashboard.

The requirements:

• Display all locations on a single map and dashboard
• Link those locations on the map to their individual project sheets in Smartsheet
• Display custom information on the map related to the locations

The Considerations

Solution must be inexpensive.

Solution does not need to auto update locations since locations do not change often

Must be easy to implement. No javascript/coding.

The Solution

1. Pull all current project addresses into a single report/sheet.
2. Upload to Google Sheets.
3. Import into MyMaps.Google.com
4. Share map and embed on Dashboard.

Step By Step Details

For detail on how to get this setup on your dashboard, watch the video below.

https://youtu.be/1ttN_C35ljM

For any questions, please feel free to get in touch at Ryan@WorkflowCreative.com

Arsineh

Great tip @Ryan Sides

Ryan Sides

Thanks @Arsineh ! Hope it helps someone.

Andrée Starå

Nicely done @Ryan Sides! 🤩

Ryan Sides

Thanks Andree! It was a fun solution.

Jake Gustafson

Stumbled across this and love it. Wondering if Data Shuttle could work to automatically output the Smartsheet data into a Google Sheet to seamlessly update the map on the Dashboard. I'm new to Data Shuttle and will need to identify a suitable Google Account to leverage so I'm not creating with my personal account.

Ryan Sides

https://community.smartsheet.com/discussion/comment/413932#Comment_413932

I created one for the client (they are free) so my face wouldn't show up on their maps. :)

DataShuttle is a good idea to update the sheet, but the breakdown is in the google maps app. It doesn't autoupdate from the updated sheet.