Thing "is in" vs "is not in" a list

Questions
1

Is there a way to check if a Thing “is in” vs “is not in” a list?

I would like Duplicate 1wk = “yes” if the number is in the list.

Screen Shot 2020-09-16 at 6.58.26 PM
Screen Shot 2020-09-16 at 6.58.26 PM724×780 65.6 KB

2

You can try

1wk changes:first item’s 1wk Changes contains …

3

Contains will only allow for the first part of the equation

4

I was actually running into this myself - Since there is only “is not in”, you’d think it would have “yes” or “no” at the end to say “Yes this item IS NOT IN my list” or “No, this item IS IN my list”. … My guess is you’ll need to find a way to use @reger-alexander’s “contains” recommendation - You may need to store the first part of your equation in a state?

5

Sorry this is in a BEWF which can’t use states, right?

I was thinking of creating a temporary field to store the solution of the equation in the database and then using it with contains.

6

Ah yea, you’re correct :frowning: The temporary field sounds like a great idea!

7

You could try this solution: List 1 contains "at least one thing" of List 2

8

I had this problem and found a native solution.
To say “X item is in Y list”, say:

“X item is not in Y list: formatted as number(1 for yes, 0 for no) is 0”

1 Like