nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

This Post is Archived and Read-Only

The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.

Browse Active Topics

Using OR in filters

Alex Cleater

Is there a way of using OR when applying filters to a column? Currently if I try mulitple criteria, it seems to apply AND, which doesn't work for my particular filtering needs.

Thanks all.

Alex

Comments

Atus Bartal

Alex,

I also had this issue a couple of weeks ago. What helped me is kind of "negative" filtering: I chose "not equal to" twice, then clicked on the "Exclude selected items" checkbox. It gave me the values next to the "not equal to" options.

I hope it helps.

Atus

J. Craig Williams

If this is a filter you use often, then I would make a column for it.

Here's the formula for an OR using NOT and AND.

=NOT(AND(NOT([Chk1]23), NOT([Chk2]23)))

Craig

Alex Cleater

Thanks Atus and Craig. I'll give this a go.

Alex