contain formula

[lilyyangadsk]

hi,

i have issue when i use contain formula for it, i tried to filter these contains([stage],"closed") deals, but somehow the result come out never include item 1 and 2. can you coach me on how to do this filter formula?

1. 5-closed/won
2. closed/lost
3. closed

[JoeS · Accepted solution]

Hi @lilyyangadsk

That appears to work for me. The contains functions returns a 0 when false and a -1 if it is true. 

Are you able to show you results window with the above function in the formula?

Here is mine:

[lilyyangadsk]

thank you , it works.

[JoeS]

You're welcome. If you use it in a filter tool it should split the data to the true and false how you require as well.