Filter tool question

Question

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 Answer

Use AND in a single formula:

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

Chris

jeff_reynolds · Accepted Answer

@ChrisTX is correct.

Try the attached workflow to see that logic in action.

Edit: updated workflow with another example.