Scenario:
John has a list of projects on one board. He has another board with tasks linked to the project board. On the projects board, he would like to put in a column showing the earliest due date for any remaining task. (to see which project is the most urgent). Unfortunately, when he tries to do so, he sees that the mirror column only shows the due date of the very first task, which was finished months ago. He wishes he could make the mirrored column show him the earliest due date after filtering out all closed tasks.
Solution: add an ability to filter a mirrored column to only mirror links that meet certain conditions
I would like to add that I think this would be really powerful.
The current workaround for this is to create additional formula columns. However, maintaining these can be complex and often creates clutter on boards.
@CSG@monday-team This would be EXTREMELY useful, and it is being used by others in the space. Would love to know if there Is there any sort of dynamic filtering on the roadmap? I know Smart-suite has this, and Airtable just added this feature.
I was just about to add this feature request, but glad to see that you did already and that it has some votes!
I would add: Allow the API to filter those filtered mirror columns.
There are numerous scenarios where a Mirror Column filter would be useful. My current one is regarding a list of people and their medical records. There is a 'Patient" board where patients are connected to different medical visits with different Doctors.
My client organization would like to be able to see, while on the “Pateint” board, how many times a patient has seen a specific doctor. In this case, the Dr. Names column would be filtered, which would allow a mirrored appointment count column to be filtered by that criteria. The resulting Sum for the appointment count column would have my answer.
Depending on how many doctors you are managing, this could be possible by using a status label for the doctor.
Alternatively, you can use formula columns with conditions and use 1/0 depending on if they have seen a specific doctor on that visit. Add columns for all doctors (if this is viable—again it depends on the number of doctors in the system) and then mirror+sum those columns for a total/doctor.
Also, this filter is possibly better used on the “Visits” board, where the information you described should be quite easy to find. You could also create a Patient dashboard with information like this in charts/stacked bar charts. Just by filtering the patient, it should be relatively simple to access that information in the structure you’re describing.
With regards the API, actually this is quite possible using the items_page request. You can use column values conditions to create query rules that only return values based on connected items. By querying the “Visits” board, you could query a specific doctor and patient for this total.