Hi all. Does anyone know how to know if a value of a list is in another list?
Solved! Go to 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.
User | Count |
---|---|
43 | |
26 | |
23 | |
14 | |
13 |