How do I present a sum of a column from Board A in a specific field in column in Board B,?

Platform discussions monday apps & integrations
,
1

The purpose is every time there is a change in any of the fields in a specific column in Border A so the summary of all the fields in the column in board A is changed, so I want to have update a specific field in a column in an item in Board B ?

2

Hey! It sounds like you wants to sync data between two boards on Monday.com, specifically:

  • Whenever any item in a specific column of Board A is updated,
  • A summary (maybe a total or concatenation?) of that column across all items is recalculated,
  • And then this summary value should be pushed to a specific column in an item on Board B.

Here’s how you could approach it:

Since Monday.com doesn’t support native cross-board column summaries, you’ll need to use Make (Integromat) or Zapier, or custom code via Monday’s API. But here’s a workaround using Monday automation + connected boards + mirrored columns + a dashboard (semi-automatic way):

:repeat_button: Option 1: Automation via Monday.com (with limitations)

  1. Connect Boards:
  • In Board B, create a column that connects to items in Board A.
  • Add a mirror column that reflects the values from the specific column in Board A.
  1. Use Dashboards or Formula Widgets:
  • Use a dashboard with a Chart or Formula Widget to summarize the values in Board A’s column.
  • But: you can’t directly push that result into a column in Board B with default automations.

Or Option 2: Use Make.com

  1. Trigger:
  • Set a Make scenario to trigger when any item’s column value changes in Board A.
  1. Aggregate:
  • Fetch all items in Board A and sum up or summarize that specific column.
  1. Update:
  • Update the specific column in the specific item in Board B with the new summary value.

Example: “If the ‘Sales’ column in Board A is updated, recalculate total sales and push to the ‘Total Sales’ field in Board B’s summary item.”

Hope this is some help and gives you ideas to get it working and Syncd!

3

You can doe this with the Rollup Multiple Boards app. The app is designed to rollup multiple values from multiple boards (based on templates) and might be an overkill if you just want to have the summary of one board and one column.