Issue with Exporting Aggregated Subitem Data to Excel

Platform discussions monday apps & integrations
, , , , , ,
1

Hi everyone,

I’m encountering a problem with exporting aggregated subitem data to Excel from Monday.

Here’s the scenario:

  • I have a board with subitems that track the number of days each employee has spent at specific companies. Each subitem has a column with a formula like IF({Company} = "BRASKEM", 1, 0) to mark the presence of the employee at the company.
  • In the parent item, I have a summary column that aggregates these subitem values to show the total number of days each employee has been at “BRASKEM”.
  • The aggregation works perfectly within Monday.com, displaying the correct totals.

However, when I export this data to Excel, the aggregated columns come out incorrectly formatted, showing values like 0,0,0,1,1,1,1,0,0,0,0,0,1,0,1,0 instead of a single total value.

Steps to reproduce the issue:

  1. Create a board with items and subitems.
  2. Use a formula in the subitems to mark values (e.g., IF({Company} = "BRASKEM", 1, 0)).
  3. Aggregate these values in a parent item column.
  4. Export the board to Excel.

Expected result: The aggregated column in Excel should display the correct total number of days.

Actual result: The aggregated column shows a series of 0s and 1s instead of the total.

Has anyone else encountered this issue? Is there a workaround or a proper way to export these aggregated values correctly to Excel?

Any help or insights would be greatly appreciated!

Thank you!