Filter Ref based on a different column in referenced table

[Binkodyl]

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]

What have you tried? Screenshots, please.

[Binkodyl]

Filter condition for slice

Valid_If formula for column of ref type

List VC I created in Document Type table.

End Result.

[Steve]

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:

help.appsheet.com

IN()

Is item in list?

help.appsheet.com

INTERSECT()

Items common to two lists