I want to do a validIf that checks a text entry against a list in a different table. Its valid if it’s in that list. My issue is if I use Table[ColumnName] it displays the entire list. I dont want it to show the list only check against it.
A Valid If expression consisting solely of a list or an IN() expression will be handled magically and automatically presented as a drop-down menu. To prevent this magical handling, wrap the IN() expression in a benign AND() or OR() expression.
For instance, you want to check whether the column’s value is contained in another column:
MyTable[SomeColumn]
which is equivalent to:
IN([_THIS], MyTable[SomeColumn])
Either of the above would produce a drop-down menu. To avoid this and just test tor the value’s presence, use:
OR(IN([_THIS], MyTable[SomeColumn]), FALSE)
or:
AND(IN([_THIS], MyTable[SomeColumn]), TRUE)
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |