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

Jonathan-Sherman

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

20200428 - BothValueFilters.yxmd