Hi all- I am having the darndest time when exporting data that is either a formula or a mirror column. When I export this data that may be summing in a mirror column lets say 1 2 and 3. In the monday.com board I see a total of “6” but when I export I see in that same column “1,2,3” which is frustrating.
Anybody have a work around for this? I’m open to suggestions
Hi @aza.rose - is this mirror column summarizing data from multiple boards?
Mark
There is a workaround which fixes the issue, but it is a little annoying, and would mean you would need to clean up your export.
Try using a Function column and just putting in {column name}, so it mirrors the data in the column that’s not exporting correctly.
When you do the export, you will just need to delete the column from the sheet.
Depending on what you are exporting, and why, there might be other options with Dashboards or Documents. Happy to talk more about it if you want.
Hello, @aza.rose
You’re encountering an issue where the exported data shows the individual values instead of the summed total from the mirror column. This can indeed be frustrating! Here are a few workarounds you might find helpful:
Use a Formula Column: Instead of relying on the mirror column for summing, you can create a formula column that directly calculates the sum. This way, when you export, the summed value should be retained.
Export as a Different Format: Sometimes exporting as a different file format (e.g., CSV instead of Excel) can help preserve the calculated values. You can then open the file in Excel and see if the summed values are retained.
Manual Summing: If the above methods don’t work, you might need to manually sum the values in Excel after exporting. You can use the SUM function to quickly add up the values.
Third-Party Tools: There are third-party tools and scripts that can help with more advanced data manipulation and export tasks. These might offer more control over how data is exported and formatted.
Best Regard,
AARP Mahjongg
OMG YOU ARE A LIFE SAVER!!! I used the formula column and in the formula I just put {Column Name} and when it exported it was exactly what I was looking for. Thank you thank you thank you! I feel silly that the answer was so easy
This did it! Thank you thank you thank you
Hello, Aza,
There is another way to convert the values that appear in a cell separated by commas. I usually do this because I use the latest version of Excel.
Just create an Excel column with the formula below. It will convert and totalize the data. =SUM(NUMBERVALUE(TEXTSPLIT(A1, ",")))
Best regards,
