Function to Check if a List is a Subset of Another List

[Clark_Villocill]

With:

A = {1, 2}
B = {1, 2, 3, 4, 5}

Perhaps a function like SUBSET(A, B) returns TRUE

I can do a workaround on this by doing a comparison check:
INTERSECT(A, B) = A

but since I use a lot of SELECT() expressions in coming-up for a list, the expression would be very long. Hoping the developers will add this feature

[Marc_Dillon]

Have you tried
IN( A , B )
?

Saw in another thread a couple weeks ago that IN() works like that now, with Lists.

[Clark_Villocill]

Hi @Marc_Dillon . Tried it out in a virtual column. It only works on finding-out if a single item (or a list with single item) is found in a bigger list.

[Marc_Dillon]

Oh, my bad, I was thinking of the wrong thing. Here’s the post from before:

Having trouble with expression for turning a field into a list for using in a IN() expression Questions

Whoa…crazy. [image]

[Clark_Villocill]

Nice one! Will surely be useful for similar requirements for the app in the future