Filter over multiple columns with AND and OR

Options

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

Best Answer

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Answer ✓
    Options

    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!

Answers

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Answer ✓
    Options

    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
    Options

    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