Hi Monday community! 
As you know, using mirror column give us the possibility to display linked values as a sum, a count, etc.
Is there a way to display these linked values as a SUMIF?
Making the sum only for a given condition as illustrated below:
Thanks in advance
Hi Emmanuel!
On Board A, add a formula column which only displays the % if Status = OK:
Mirror the formula column instead of the main % column on Board B to achieve the SUMIF function you’re looking for:
Thanks a lot Megan, great approach
How did you display the “%” at the end in group B?
The formula returns an integer on my side and if I add it at the end of the formula (adding &“%”) I cannot make a sum in the mirror column.
I had to complexify a few the formula due to multiple criteria to be considered but using the same formula as your gives me the same behavior.
IF(FORMAT_DATE({Roll-On / Roll-Off#Start},“YYYY-MM-DD”)<=FORMAT_DATE(TODAY(),“YYYY-MM-DD”),IF({Status}=“Booked”,{% Allocation},0)+IF({Status}=“To be booked”,{% Allocation},0)+IF({Status}=“Booking requested”,{% Allocation},0),0)*100
I ALWAYS hide the summary 
I didn’t know this feature, thanks a lot (again)!!
