Requesting an .IsIn() formula

I’m not sure if there’s a feature like this already, but I would love an isIn() formula. I usually do not(contains()) but sometimes it’s really clunky and it would be awesome to just have an isin() to see if a value is in a list or not.

Hi @Samuel_Langford :blush: !

Would In() help you ?

in() and contains() are very similar, but the syntax is reversed. Contains() differs from in() that when checking on more than one value at a time, contains() returns true if any of these values are found, while in() checks only on one item.
By changing your syntax it becomes a lot more readable:

list.contains(search).not()

2 Likes

:sweat_smile: Never noticed this formula. I’ll test it out.

1 Like