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.

的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[email protected]

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.