Valid If on a List

[1minManager]

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.

[Steve]

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)