Syncing Calculated Values Across Boards: Using Mirror Columns to Pull Formula Results Without Errors
Mirror columns can display formula results from connected boards automatically, but trying to use those mirrored calculations in further formulas or automations often leads to frustrating errors. While monday.com's mirror columns excel at pulling calculated values across boards, they have specific limitations when it comes to using that data in automated workflows.
What Are Mirror Columns and How Do They Handle Formula Results?
Mirror columns automatically display data from connected boards, including the results of formula calculations. When you mirror a formula column, you're seeing the calculated output, not the formula itself. This means if Board A has a formula calculating "Progress = Complete Tasks / Total Tasks", Board B can mirror that percentage value and display it in real-time.
The mirrored data updates automatically whenever the source formula recalculates. If someone marks another task complete on Board A, the mirrored progress percentage on Board B updates immediately without any manual intervention.
For numbers columns, mirror columns offer aggregation options like sum, average, minimum, and maximum. This is particularly useful when one item connects to multiple items on another board — you can display the total of all connected values rather than seeing individual numbers.
Why Formula Columns Can't Reference Multiple Mirrored Values
One of the most common frustrations occurs when trying to create formulas that reference mirror columns displaying multiple values. You'll encounter the error: "Formula with multiple mirrored values is not currently supported."
This happens when your mirror column aggregates data from multiple connected items. Even though the mirror column displays a single summed value on screen, monday.com's formula engine sees the underlying individual values and refuses to process them.
For example, if you're trying to calculate a completion percentage by dividing a mirrored "Complete Tasks" sum by a mirrored "Total Tasks" sum, the formula will fail even though both mirror columns show single aggregated numbers.
The workaround is to use mirror columns that reference single items only, or copy the aggregated values to regular columns first using automation blocks like Copy Mirror Column Value to Editable Column.
Can Mirror Columns Trigger Automations?
Native monday.com automations cannot use mirror columns as triggers. Mirror columns don't appear in the trigger dropdown menus, and you cannot create automations that fire when mirrored values change.
This limitation extends to using mirror column data in automation actions. You can't include mirrored values in dynamic notification text or use them to conditionally update other fields.
As explained in our guide on Mirror Columns in Automations, the fundamental issue is that mirror columns are read-only display elements, not interactive data fields that the automation system can monitor or reference.
Working Around Mirror Column Automation Limitations
The most reliable workaround involves copying mirror column values to editable columns using custom automation blocks. Community Cookbook's "Copy Mirror Column Value to Editable Column" action can take any mirrored data and write it to a regular column where it becomes available for triggers, conditions, and dynamic references.
This approach works for both single-value and aggregated mirror columns. Once the data is copied to an editable column, you can:
- Use it as a trigger when values change
- Reference it in formula calculations
- Include it in automated notifications
- Apply conditional logic based on the values
For organizations needing to sync calculated values across multiple boards regularly, setting up automated copying creates a reliable pipeline where formula results flow from source boards to destination boards and become fully accessible for further automation.
Multi-Board Mirror Column Strategies
Mirror columns support up to 2 levels of depth — you can mirror from Board A to Board B, then from Board B to Board C, but not further. This creates opportunities for complex calculated value syncing across project hierarchies.
Consider a scenario where individual task boards feed calculated completion percentages to department boards, which then aggregate those percentages and feed summary data to an executive dashboard board. The first mirror pulls individual calculations, the second mirror aggregates departmental summaries.
When setting up multi-board mirroring with calculated values, ensure all source boards use identical column types. You cannot aggregate a Status column from one board with a Numbers column from another, even if they conceptually represent similar data.
For complex scenarios requiring more than 2 levels of mirroring or different column type aggregation, consider using cross-board sync automations detailed in our Cross-Board Sync Without Infinite Loops guide.
Data Integrity Considerations When Syncing Calculated Values
When exporting data from boards containing aggregated mirror columns, monday.com exports the raw individual values rather than the calculated sums displayed on screen. If your mirror column shows "15" as the sum of 5+4+6, the export will contain "5,4,6" instead of "15".
This creates reporting challenges when your external systems expect the aggregated calculated values. The workaround is copying aggregated mirror values to regular columns before exporting, ensuring data consistency across all outputs.
Additionally, if source boards containing formula calculations are deleted or archived, all connected mirror columns lose their data immediately. When syncing critical calculated values across boards, implement backup data copying to prevent loss during board lifecycle changes.
Best Practices for Calculated Value Syncing
Structure your board relationships to minimize mirror column depth while maximizing automation compatibility. Keep formula calculations on source boards and use automation blocks to copy final results to destination boards as editable data.
For recurring calculated value syncing, create template automations that copy mirror column data on schedule or when source values change. This ensures your destination boards always have the latest calculations available for further automation and reporting.
When possible, design your board structure so critical calculated values exist as regular formula columns rather than mirrored formula results. This provides maximum flexibility for automation triggers and cross-board workflows.
Frequently Asked Questions
Related Articles
Syncing Connected Item Data Across Subitems: Advanced Parent-Child Automation Strategies
Master advanced parent-child automation in monday.com. Learn cross-board subitem linking, data cascading strategies, and why native automations fall short for complex hierarchies.
Write Value to Connected Board Column: Push Data Across Boards Without Bidirectional Chaos
Learn when one-way cross-board data push is safer than two-way sync in monday.com. Avoid infinite loops while keeping connected boards in perfect sync.
Number Column Comparison Trigger: Automate When a Number Column Exceeds Another Column's Value
Monday.com can't natively compare two number columns in automations. Here's how to trigger actions when one column exceeds another using formula workarounds.
Ready to supercharge your monday.com automations?
Join the Community Cookbook and get a growing library of custom triggers and actions that monday.com can't do natively. Always £9.99/month — the price never goes up, but the recipe list keeps growing.