Solved: How to add additional options to CONTAINS - Page 2

WillA108 · 03-28-2021 10:45 AM

Hello!
I am trying to figure out how to add more than one option for CONTAINS.
Here is what I currently have, I definitely have a very low understanding of the logic for formulas:
CONTAINS([Day Notes], “crock” ) CONTAINS([Day Notes], “usb”) CONTAINS ([Day Notes], “trade”)

It doesn’t need to contain all phrases, just one or the other or multiple. I’m using this for a format rule.

Thanks in advance

Lynn

@WillA108
Do you want
OR(CONTAINS([Day Notes], “crock” ),([Day Notes] = “usb”), ([Day Notes]= “cooler”))

or this

OR(CONTAINS([Day Notes], “crock” ),CONTAINS([Day Notes], “usb”),CONTAINS([Day Notes],“cooler”))

NOT TESTED
I removed the extra parenthisis before the second CONTAINS and a space. Does that still work?

View solution in original post