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

telaholcomb · 2020-09-17T02:09:53.680Z

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 PM724×780 65.6 KB

reger-alexander · 2020-09-17T08:02:25.187Z

You can try

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

telaholcomb · 2020-09-17T13:34:03.709Z

Contains will only allow for the first part of the equation

w.fly · 2020-09-17T13:44:27.182Z

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?

telaholcomb · 2020-09-17T13:51:05.872Z

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.

w.fly · 2020-09-17T13:55:09.007Z

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

LWeiLi · 2020-10-26T06:46:56.357Z

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

bridger.oneill · 2022-11-03T18:32:14.286Z

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”