Sync Formula Columns Across Boards in monday

You build a slick formula column to calculate something important—like budget overages, project delays, or employee productivity scores. It works perfectly… on one board.

But then you need that formula result elsewhere—in another board, maybe in a report or to trigger automations. You quickly realize: formula columns don’t sync across boards. Now you’re stuck duplicating logic or copying values manually.

Why This Becomes a Bottleneck

Without cross-board formula syncing:

  • You’re limited to board-level logic only.
  • You can’t build true roll-up views or executive dashboards.
  • Your workflows get fragmented—especially in complex setups like PMOs, finance ops, or cross-department projects.

It blocks scalability and wastes time.

VLOOKUP Lets You Mirror Formula Values Across Boards

With VLOOKUP by Jetpack, you can pull the results of a formula column from one board into another—just like a lookup function in a spreadsheet.

This lets you:

  • Reuse calculated results across boards
  • Combine formula values with other synced data
  • Build cross-board reporting and automation logic

How to Connect Formula Columns Using VLOOKUP

Step 1: Install VLOOKUP

Get the VLOOKUP app from the monday.com marketplace if you haven’t already.

Step 2: Set Up a Text Column in Your Target Board

Formula values can’t be mirrored directly—so in the target board, add a Text column to receive the formula result from the source board.

Step 3: Match the Boards Using a Unique Key

Set up a matching field that exists in both boards—like “Item ID,” “Employee Email,” or “Project Code.” This is how VLOOKUP knows what to link.

Step 4: Create a VLOOKUP Recipe

In the VLOOKUP app:

  • Select your source board (where the formula column lives)
  • Select the target board (where you want to pull the value)
  • Choose the formula column as the source column
  • Set your target column (the Text field) to receive the value

Step 5: Choose the Right Trigger

Use a trigger like “When item is created” or “When item is changed” to make sure the lookup happens at the right moment.

Result: Seamless Cross-Board Logic That Actually Works

Now your formula values can live beyond a single board:

  • Finance can calculate costs on one board and reference them in client or department boards.
  • Project managers can pull in calculated risks or time delays from sub-boards.
  • HR can sync performance scores with feedback workflows.

Recap

Formula columns are powerful—but isolated. VLOOKUP makes them portable, practical, and part of a larger monday.com ecosystem.

Use it to turn formulas into scalable, reusable logic across your workspace—no copy-pasting, no redundancy, no limits.

Join a mailing list 

Joining a mailing list with insights and tips how to
improve productivity and efficiency on monday.com

Related Articles