Filter Ref based on a different column in referenced table

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.

What have you tried? Screenshots, please.

Filter condition for slice

Valid_If formula for column of ref type

List VC I created in Document Type table.

End Result.

1 Like

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: