Map View Optimization - Link to Formula Column

Platform discussions
, , ,
1

I am using the map view to track locations that my colleagues have done inspections of our assets. Right now, the map shows a number related to how many ‘items’ or inspections have been done at a specific asset location.

I believe the number displayed on the map should have an option to be able to be to be linked to a formula column on my board that shows the average inspection score for my specific asset. This would allow me to quickly see on a map view what assets are scoring poorly.

2

Hey @katrina.perez,

You’re absolutely right in your thinking, and what you’re asking for is a very practical and insightful feature — but unfortunately, as of now, Monday.com’s Map View does not support displaying values from formula columns (like an average inspection score) directly as the label or marker number on the map.

Currently, the Map View can show a count of items per location and lets you open a group of items at a specific point, but it cannot replace that count with a value from a formula column or display custom data like an average score.

Workaround Options:

Here are a couple of possible workarounds that could help you visualize inspection scores geographically:

  1. Use a Dashboard with a Map Widget + Chart/Table Widget
    Create a dashboard where you use:
  • The Map Widget to show inspection locations.
  • A Chart Widget or Table Widget to display average scores grouped by location or asset. This won’t directly link the two, but it gives a side-by-side view for quick comparison.
  1. Use Color to Indicate Score Ranges
    While you can’t show the formula value, you can use status columns or tags to represent score ranges (e.g., Good, Average, Poor) based on your formula. These tags or statuses can be seen when clicking a location on the map.
  2. Third-party Integration or Automation
    If you’re comfortable with tools like Make (Integromat) or Zapier, you could potentially:
  • Automatically populate a text or number column with your average score from a formula.
  • Use that column in custom visualizations outside Monday.com (e.g., Google Maps, Power BI, Tableau).