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
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:
User | Count |
---|---|
43 | |
28 | |
23 | |
14 | |
14 |