Hello I need help with CONTAINS()

[Peter_Jenkinso1]

Hello I am trying make a condition yes/no for a action

I am trying to get two columns to work so it comes back true
CONTAINS([Asset], “LDB”) & CONTAINS([Job Plan], “JP1”)

this one works by itself fine
CONTAINS([Asset], “LDB”)
but i want to add this also
CONTAINS([Job Plan], “JP1”)

Any help will be much appreciated

[Koichi_Tsuji]

Wrap the two expression by and() expression.

AND(CONTAINS([Asset], “LDB”) , CONTAINS([Job Plan], “JP1”))

[Peter_Jenkinso1]

what you I do if i want it to be like or between them

ANY(CONTAINS([Job Completion], “In Progress”) , CONTAINS([Job Completion], “Not Started”))

so if there is Not Started or In Progress it comes back true

[Koichi_Tsuji · Accepted solution]

OR(CONTAINS([Job Completion], “In Progress”) , CONTAINS([Job Completion], “Not Started”))

??

[Peter_Jenkinso1]

Thanks very much for the help and fast reply it worked great
Have a great Day