Contains Formula

[Bruno_Cambrais]

Hey Guys,

Does anyone know if the Contains expression can be used to identified multiple text values in a column?

For example, I want to filter the rows that contain the text value Coke or Coca-Cola.

Thanks,
Bruno

[Marc_Dillon]

No. Use 2 CONTAINS(), along with:

help.appsheet.com

OR()

Are any true?

[Bruno_Cambrais]

Thanks Marc,

I created a slice where I used the Contains formula but I don’t know how to use along with OR(). Can I use the OR formula on Slice along with Contains or should I add the formula somewhere else?

Bruno

[Marc_Dillon · Accepted solution]

In same place:

OR( CONTAINS(…) , CONTAINS(…) )

[Bruno_Cambrais]

AMAZING MARC

Thanks, it’s working now!