Solved: IN for multiple values - Page 2

Pratyay_Rakshit · 10-18-2020 10:42 PM

I can now use IN for searching ONE value.

Like

IN (Value, LIST())

Can this be done :

IN({Value1, Value2, Value3…}, LIST())

?

Suvrutt_Gurjar

Please try something like below

COUNT(INTERSECT(LISTA , LIST B)) >0

Or following

COUNT(INTERSECT({A, B, C}, {A, B, C, D, E, F}))>0
in a constraint or Y/N type column or filter or condition type of setting

Or something like below if your using the statement in say text type column

IF( COUNT(INTERSECT({A, B, C}, {A, B, C, D, E, F}))>0 , “Whatever message you wish on statement being true”, “Whatever message you wish on statement being false”)

Edit: Minor correction in typo errors.

View solution in original post