Also waiting for a workaround - as for now we usea Formula Column which shows the text value from the mirror column
Adding a formula column is a workaround.
Please reconfirm the formula.
We are trying to filter based on a country column that is mirrored
Hi Rosalind,
Here’s the formula as I’ve been using it:
IF({MIRROR COLUMN NAME}=“Empty”,“”,{MIRROR COLUMN NAME})
Hope that’s helpful.
thank you that works perfectly.
Wow, it looks like this post has already had a lot of activity with little change. Our issue is exactly the one posted by @hdurey above (post #33 explaining that a mirror of a mirrored column cannot be filtered or sorted). An update would be appreciated. Is support doing anything about this, working toward a resolution, or is this still at the bottom of the priority list? I will say for all the issues we are having with Monday.com funtionality, this is by far #1.
Hi! Waiting on this to be corrected as well! We have a lot of boards mirroring off each other but the fact that you can not sort is a huge issue for us!
Please advise!!
The formula is not working for me wen I am trying to use dates.
These discussion groups are hard to follow - I can’t tell if Monday is claiming that this works or knows that it doesn’t. I have a simple case of mirroring some columns on another board. The column that shows the connected item (which is of course text) can be sorted. Any mirrored columns that are numbers or text or status from that connected board can be sorted. However, if I have a column in that connected board that is showing a summary of a subitem column, then it cannot be sorted. If this is a known limitation, can Monday please update their documentation to admit this. And, can you please indicate if it will remain a missing feature into the future (because it is for some reason difficult to do), or if you will at some point add this feature? Currently, to get around this I create a formula that is simply equal to the mirrored column value, and I can sort on that (but that means I have to have two columns for every column I want to mirror - and there are limitations on what you can do with formula columns so that causes other issues).
(Bumping this thread)
The problem with this workaround is that it is not possible to copy the contents from the formula cell. Which is needed often.
I guess with most tools nowadays I still miss these simple UX features. Understand now why Excel is still the king.
Only works for the initial mirrored information - if you mirror information from Board A to Board B, and then want to mirror that same information from Board B to Board C you can see it but can’t filter by it on Board C which defeats the purpose of not inputing the same information multiple times/multiple places.
Hello.
2024 and there is no news regarding this issue.
I agree with someone earlier that said that is hard to follow this threads…
ISSUE:
I cannot sort mirrored date or location columns.
But I can sort other mirrored columns.
This is quite painful. With a board with hundres of items. It’s imposible to work on there without being able to sort by date…
How can we solve this?
It’s very important.
I just encountered this issue and was told by Support to submit a feature request, so here I am. However, this feels like a bug that should have been fixed long ago rather than a new “feature” to create. It’s discouraging now to see that this has been outstanding for 3 years. I’m trying to create a board that can be shared with my executive team, but I can’t share something that is so obviously broken. As stated above, “this is quite painful.”
@BiancaT – Do you know if this is something that will be addressed in the near future?