We cannot create filters that are AND as well as OR, correct?

For example:

email is signed in user OR
email is team manager
archived is not true

I have not found a way to do this and I really want to! :grin: Just checking to make sure I’m not missing anything!

You are correct, but you can get creative by creating your AND’s in the data editor and just use the OR’s in the filter.

1 Like

Thank you Jeff! How would I put the and’s in the data editor? sorry haha- I am still learning every day!

You’d just create a column in the data editor that creates all the conditions you need with AND. Then that column would be one of the OR columns in the component you’re filtering.


For example:

I want the component to filter when Color 1 is Red AND Color 2 is blue OR Color 3 is green.

In the Data Editor I create an IF - THEN - ELSE column called “Colors 1_2” that checks the Color 1 and Color 2 columns and IF Color 1 is Red THEN true, IF Color 2 is not Blue THEN false, IF Color 2 is Blue THEN true, IF Color 1 is not Red THEN false.

That column will check each condition one after the other and should give you “true” if Color 1 has Red AND Color 2 has Blue… but “false” if either of them doesn’t have its Red or Blue respectively.


Now go back to your component and filter it as such: Color 1_2 is true OR Color 3 is Green.

1 Like

John what about when you have tiered and/or conditions?

And this image just involves two tiers…


1 Like

Ah, okay, now I get it. Thank you so much for the detailed explanation. I have used If/Then/Else but I didn’t think about it for this use case.

1 Like

Having trouble understanding what you mean and I could probably get it if I could see the image, but it’s tiny and my eyes just aren’t what they used to be lol

1 Like

Ah, I knew I saw this somewhere. Thank you!