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.

image
Sync Formula Columns Across Boards in monday 4

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.

AD 4nXdkVnwJDrtbwwLAPG8WbjnN2YhsmG4FuXHpJnh45xadEyeXMmeZ 3YSU8dxfX0T0Jk y R ZikaVStF30SaopERqrJuM0VCHuCzMxs ocAnTsMF6wRfyMSfEyZVTpu29yghcURlfg?key=dDw2L1Y1Ktuor6ZcwLTfX6wC

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
AD 4nXe9T8gkmDaROlQp73Q22J6y5mZ0CwwDE8Dv1te75q0cVSs1Kqo8Hl6EZEGB m1JDbBRbnqE W kD9jiqqBku6MDzAhU09zohJTQte2r4alhc7dKiJDFfco7Nu0q220vVrkUp7i96w?key=dDw2L1Y1Ktuor6ZcwLTfX6wC

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