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
Solved! Go to Solution.
Use AND in a single formula:
!CONTAINS([Status Upon Delivery], "error") AND !CONTAINS([Email], "sales") AND ....
Chris
@ChrisTX is correct.
Try the attached workflow to see that logic in action.
Edit: updated workflow with another example.
Thanks both, this is great.
I will work on the expression writing.