Hello I need help with CONTAINS()

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

Wrap the two expression by and() expression.

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

3 Likes

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

1 Like

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

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

??

3 Likes