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
Solved! Go to Solution.
OR(CONTAINS([Job Completion], โIn Progressโ) , CONTAINS([Job Completion], โNot Startedโ))
??
Wrap the two expression by and() expression.
AND(CONTAINS([Asset], โLDBโ) , CONTAINS([Job Plan], โJP1โ))
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โ))
??
Thanks very much for the help and fast reply it worked great
Have a great Day
User | Count |
---|---|
41 | |
36 | |
28 | |
23 | |
16 |