Find out if a value in a list is in another list

Hi all. Does anyone know how to know if a value of a list is in another list?

Solved Solved
0 6 1,632
1 ACCEPTED SOLUTION

Oh if you want to see if the item is in the table or not, you can use the IN() expression.

So on the format rule "If this condition is true" you can use

NOT(IN([_THISROW].[IDColumn], OtherTable[RefColumn])) 

This assumes that you have a ref column between the two tables.

View solution in original post

6 REPLIES 6
Top Labels in this Space