Reference Boards

Controlled data beats free text every time.

Reference Boards

Killing Free-Text Chaos (and Why Dropdowns Aren't Enough)

Most broken Monday.com systems don't fail because of automations.
They fail because of free-text data.

Someone types:
- "North East"
- "Northeast"
- "NE"
- "north-east"

And suddenly:
- dashboards don't add up
- automations misfire
- reports lie

Reference boards exist to prevent this.


What a Reference Board Actually Is

A reference board is a controlled dataset that represents shared, stable information used across multiple boards.

One item represents:
- one region
- one service
- one product
- one pricing tier
- one category that should never drift

Unlike operational boards, reference boards:
- change infrequently
- have few editors
- act as a source of truth


Why Free-Text Is a System Failure, Not a User Failure

Free-text fields feel flexible.
They are also destructive.

Free-text causes:
- inconsistent values
- unreportable data
- brittle automations
- endless "cleanup" work

The problem isn't that users type badly.

The problem is that the system allows ambiguity.

Reference boards remove ambiguity entirely.


Why Dropdowns Are Better — and Still Not Enough

Dropdown columns are an improvement:
- they limit choices
- they improve consistency
- they're quick to set up

But dropdowns fail when:
- values need metadata
- values need to change over time
- values are shared across boards
- reporting spans multiple dimensions

A dropdown can't tell you:
- which region a market belongs to
- which pricing tier is active
- which services are deprecated

Reference boards can.


Real-World Examples

Example 1: Regions & Markets

Instead of a dropdown:
- "North"
- "South"
- "East"
- "West"

Use a Regions reference board where each region:
- has a name
- owns markets
- maps to managers
- rolls up into dashboards

Every deal, project, or order connects to the same region record.


Example 2: Service Catalog

A services reference board:
- prevents sales from inventing services
- standardizes pricing logic
- enables reporting by service type

When services change, you update one board, not twenty.


Example 3: Pricing Tiers

Pricing tiers change.
Deals shouldn't retroactively change with them.

A reference board lets you:
- version pricing
- freeze historical data
- maintain reporting integrity


Reference Boards in System Architecture

Reference boards are rarely used alone.

They usually work alongside:
- Master–Detail Boards
- Lifecycle Boards
- Operational Hub Boards

They form the static backbone of dynamic systems.

If your system feels fragile, look for missing reference boards.


Common Mistakes

❌ Treating Reference Boards Like Operational Boards

Too many editors = chaos.

Reference boards should be:
- tightly controlled
- boring
- stable


❌ Overusing Dropdowns for Relational Data

If a value has meaning beyond a label, it deserves its own board.


❌ Forgetting Historical Integrity

When reference data changes, history matters.

Good systems preserve:
- what was true then
- not just what is true now


When You Don't Need a Reference Board

Reference boards are overkill when:
- data is truly ad-hoc
- values are temporary
- reporting is irrelevant

Not everything needs structure.

But anything you report on does.


The Core Principle

Free-text optimizes for speed.
Reference boards optimize for truth.

Professional systems choose truth.


Where to Go Next

If your dashboards don't match reality, your reference data is the first place to look.

Found this helpful? Share it with your network:

Written by Rick Apichairuk

Founder, Monday Expert

Systems designer focused on building clear, scalable Monday.com architectures. Writes about board design, data modeling, and operational patterns used in real teams.

Apply for a Live Build Session

Get your Monday.com workflow built live on stream. Real solutions, real learning, completely free.

Apply Now