Using CONTAINED IN filter using Advanced filter


In the simple filter, one of the options is 'contained in', and I'm wanting to see if there is an equivalent to that but in the advanced filter. Something like this below would result in true where testColumn = 'A':

CONTAINED_IN( ['A', 'B', 'C'] ; testColumn )

and the equivalent in the simple filter is:

testColumn    contained in    ['A', 'B', 'C']

I ask this, because I'm attempting to use a more complex filter with both &&'s and ||'s.

Daniel Mendez Estrada

1 comment

  • Avatar
    Konsta Danyliuk

    Hello Daniel.
    In this case you could use CONTAINS function at Advanced Filter.

    CONTAINS(#testColumn;"A") || CONTAINS(#testColumn;"B") || CONTAINS(#testColumn;"C")

    Please let me know if this helps you to achieve desired result.

Please sign in to leave a comment.