Filter Ref based on a different column in referenced table

[Binkodyl (Dylan Binkowski)]

I’m trying to write a Valid_If formula, for a column called [Document Type].
[Document Type] is a column of Ref type. I’m trying to filter the keys displayed in the dropdown by whether a column in the “Document Type” table contains “Bill” or “Act”.
Nothing I’ve tried seems to work.

[Steve (Steve Coile)]

What have you tried? Screenshots, please.

[Binkodyl (Dylan Binkowski)]

Filter condition for slice

Valid_If formula for column of ref type

List VC I created in Document Type table.

End Result.

[Steve (Steve Coile)]

@Binkodyl

[Document Type] is a column of Ref type.

If of type Ref, rather than List of Ref or EnumList of Ref, then this:

should instead be:

IN([Document Type], LIST("Bill","Act","Universal"))

Note IN() rather than INTERSECT(), and no COUNT().

See also:

IN()

INTERSECT()