Hey guys,
I want to calculate the profit of projects using mirror values from different boards.
Once I have 2+ items connected, the formula column doesn’t support it.
Does anyone have any solution or idea of how to solve it using make.com?
I believe that I need to pull all the connected items and extract the values and perform the formula on make.com.
Thank you in advanced
Hi @Hezibo - this should be easily enough accomplished with make.com.
You would just need to loop through the connect board column (grabbing the board IDs), then dynamically pass them in, loop through the connected items from those boards, grab the values you need and conduct the calculation in make.com. You may need to use make’s internal data stores as well depending on the complexity of the calculations to be completed.
Happy to help where we can - it’s difficult to build out an example without having the full picture 
Mark
For calculating the profit of projects using mirror values from different boards in Make.com, we can implement a scenario to gather all connected items, extract their values, and perform the necessary calculations. We’ll create an automation to fetch data from each connected item using Make.com’s Monday integration. Then, we’ll aggregate these values and apply the required formulas within Make.com, ensuring all data is synchronized and updated in real-time.
There is a workaround for this that I use that doesn’t need you to go outside Monday.com, but it does need a lot of extra columns. Create formula columns for the additional mirror columns that are simply {mirror column}. You will then be able to use those formula columns in your master formula, rather than calling the mirror columns directly from the master formula.
Hey Peter
Thank you for the suggestion.
It’s strange, I’m aware of this workaround. Sometimes it works for me and sometimes not. I couldn’t figure it out
wanted to answer here to explain.
This works when the value is a number value, if the value in the mirror column is a value from another mirror that’s when it fails.
Have you looked at the 3rd party app called Autoboost - it lets you run formulas and put the results in another column and also has automations for mirror columns along with a lot of other help automations.