Filter over multiple columns with AND and OR

KROnline

Hello,

I've a question using the filter within a smartsheet.

As an example with filtering over 3 columns A B C:

(A contains "aaa" OR B contains "aaa") AND C = "123"

Combination of "OR" bewtween two colums and "AND" to the third column seem not to be practible.

Any idea?

Thanks Kay

Nick Korna

Hi @KROnline,

The filters only appear to have either meeting one of the conditions, or meeting them all.

However, you can get round this with a helper column.

This would have the formula:

=JOIN(A@row:B@row, " ")

So for some data you'd get something like this:

Your filter would then be:

To get results:

Hope this helps!

Nick Korna

Hi @KROnline,

The filters only appear to have either meeting one of the conditions, or meeting them all.

However, you can get round this with a helper column.

This would have the formula:

=JOIN(A@row:B@row, " ")

So for some data you'd get something like this:

Your filter would then be:

To get results:

Hope this helps!

KROnline

Hi @Nick Korna ,

thanks for that - good workarround.

But regarding complex sheets with complex filters Smartsheet should make some improvements within the tool.

Best Kay