Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Trello Filtering: AND instead of OR

I like the option to filter a board by label (it's a great way to keep lots of cards in a single board without being overwhelmed with stuff).

I'd like to be able to filter for cards that show both a red label and a blue label, for example. If I choose both labels to filter, I'm shown all red labels and all blue labels instead of just the cards labelled as red AND blue. Which is what I'd expect, so fair enough. Is there a way to filter for AND instead of OR though? 

I'm aware I can search for this, but then you lose the benefit of a board and just get a list (which negates any benefits).

Any help would be much appreciated!


In case of relevance/interest:

My use case is a set of labels to group cards into sets of related tasks (product 1, product 2, experiment 1, etc), and a separate set of labels to also define what kind of task the card is (UX design, mechanics, electrics, back-end software dev, etc). I'd like things organised with labels in this way so that I can use the board lists to organise tasks into columns of grouped goals/'needs-to-be-done-by's (ASAP, for customer X demo, for internal review in April, etc). I don't want to use due dates for this, because I'd like to be able to benefit from being able to move things between columns easily, and to shift the order of whole columns as priorities change.

2 answers

1 vote

I'm not sure if this is a new feature since the last post or was just missed but, there seems to be a way to filter labels with AND vs OR now. At the bottom of the filter list, there is a toggle for Any Match or Exact Match. If you switch to Exact Match, it seems selected labels create an AND filter. Hope this helps. 


Image 4.png

1 vote
Iain Dooley Community Leader Mar 07, 2019

@JR Veale The filter is always a logical OR rather than a logical AND, however, the search is logical AND so you can use it to get a list of cards on a board that have both labels (but not only one of either):

This doesn't show you the cards in a board interface, though, it shows them in a list interface so you can't easily drag them around :(

Thanks for your answer, this is the conclusion I came to when looking around - I was hoping for a workaround or filtering feature that I'd missed.

Is there a feature request system in place where I can suggest extensions to filtering / searching? (If Trello were open source I'd be tempted to make a PR!)

Like Jenny Lauridsen likes this

AND filtering would be a great feature. I'm guessing in the background there is some SQL doing the filtering based on selected labels. Would love to be able to type this in. Being able to save this filtering would be even better.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Trello

Taco Tuesday: New years' resolutions with Trello

Congratulations to @Laura Holton , our latest winner of Taco Tuesday! And thanks to @Kristján Geir Mathiesen for sharing the picture of Taco having fun with his new friend  B...

2,256 views 27 40
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you