I need to add the totals from 1 column spanning multiple groups on a board and show that figure in a different board. I cannot see with connecting boards how to show the total value for that column on the board.
Yet, a dashboard on the board with the data in it, can show me the total - argh. Am I missing something?
Hello @Calgat
Yes, you’re right to notice that dashboards can show column totals, but the Connect Boards feature doesn’t natively sum a column across multiple groups and display the total on another board. However, there are a few workarounds to achieve this:
Workarounds to Show the Column Total on Another Board:
Use a Formula Column + Mirror Column Approach
On the original board (where the data exists), add a Formula Column that mirrors the total sum for the column you want.
Then, on your target board, use the Mirror Column to pull in the summed value from a specific item that holds the total.
Roll-Up via a Summary Item
Create a new item (e.g., “Total”) in the source board.
Use automation to update that item with the sum of your desired column.
Mirror that single “Total” item onto your target board using Connected Boards + Mirror Columns.
Use a Dashboard Widget on the Target Board
While dashboards exist on the source board, you can also create a dashboard on your target board that pulls the total from the source board using a Battery Widget or Chart Widget.
Some third-party apps from the Monday Marketplace (like “Advanced Reporting” or “Rollup Subitems”) might offer more flexibility for cross-board totals.