How to Automatically Copy Column Data in monday

You’re tracking important details—like client names, email addresses, order IDs, or employee roles—on one board. But you need that same data replicated on another board, or even in another column, to support linked workflows.

You try to do it manually. You even consider duplicating columns and building automations. But it’s clunky, error-prone, and doesn’t scale.

Why This Problem Gets in the Way

Without a way to auto-copy column content:

  • You rely on manual updates that can break or go out of sync.
  • Team members see incomplete or mismatched data.
  • Automations, reports, and formulas fail due to missing fields.
  • The more your boards grow, the more your data integrity suffers.

The Smart Fix: Use VLOOKUP to Auto-Copy Column Values

With VLOOKUP by Jetpack, you can automatically fetch and copy values from one column into another—across boards, views, or workflows.

It’s like having a dynamic “copy-and-paste” action that runs in the background, constantly keeping your data in sync.

Step-by-Step: Copy Column Values Automatically with VLOOKUP

Step 1: Install VLOOKUP from the monday.com Marketplace

Search for “VLOOKUP Auto-Link” in the App Marketplace, then install it to the boards you’ll be using.

Step 2: Identify Your Source and Target Columns

  • Source Column: Where the original data lives (e.g., Email, Client Name, Order Code)
  • Target Column: Where you want the copied value to appear

This works across two separate boards or within the same board.

Source board

Target board

Step 3: Create a VLOOKUP Recipe

In the VLOOKUP dashboard:

  • Select your Source Board and Target Board
  • Choose a unique key that exists on both (like ID or Name)
  • Set the Source Column and Target Column
  • Save and activate the recipe

Step 4: Choose When It Should Happen

Pick an activation trigger—like:

  • “When item is created”
  • “When item is changed”
  • “When sub-item is created”

This ensures the copy action happens exactly when you need it.

Use Case Examples

  • Client onboarding: Automatically copy an email from an intake form board to a communication tracking board.
  • HR processes: Copy employee role data into a performance review board.
  • Finance: Sync order amounts or invoice numbers from a billing board into reporting boards.

The Outcome: Clean, Synced Data—No Extra Effort

You don’t need to retype. You don’t need to guess. VLOOKUP handles the column sync behind the scenes, reducing overhead and improving team accuracy.

Recap

If your monday.com workflow relies on the same data showing up in multiple places, VLOOKUP gives you the most efficient way to copy column values—automatically, accurately, and at scale.

Join a mailing list 

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

Related Articles