Filter tool question

[DPRC]

Hello All,

I have a question regarding the filter tool and the "does not contain" expression. I was hoping to have 1 expression with 4/5 different phrases to remove from the data but had to apply the filter tool 4 times instead (See beneath)

I don't come from a programming background so the expression writing and the nuances associated with that, I haven't mastered yet.

How should I have approached this to?

Thanks

[ChrisTX · Accepted solution]

Use AND in a single formula:

!CONTAINS([Status Upon Delivery], "error") AND !CONTAINS([Email], "sales") AND ....

Chris

[jeff_reynolds · Accepted solution]

@ChrisTX is correct.

Try the attached workflow to see that logic in action.

Edit: updated workflow with another example. 

[DPRC]

Thanks both, this is great.

I will work on the expression writing.