Using the Contain function with the And function

[deckthehalls]

Hello all! I am trying to filter out MDW and ORD from the destination column. 

The formula I am using is:

Contains([Destination], "MDW") and Contains([Destination], "ORD")

I want something that will return both MDW and ORD if they're present within the Destiation Data as true, or either one as False if the other isn't present.

Destination

MDW

ORD

PHX

[RolandSchubert]

Hi @deckthehalls ,

in your formula, replace "AND" by "OR" and it should work.

Contains([Destination], "MDW") OR Contains([Destination], "ORD")

Let me know if it works for you.

Best,

Roland

[Jonathan-Sherman · Accepted solution]

Hi @deckthehalls,

I think this solves your issue if both values are in there:

And also solves if only one is there:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan