Hi,
Can someone help me? My Valid_if constraint in my Document[Document Type] column is returning blanks, no matter what I try. It is column type Ref, pointing to the DocLabelDef[DocType] column, but Iโve tried it as Text and Enum as well.
I have a spreadsheet (Document.gsheet) that has [Division]s and [DocType]s. There are three Divisions and 6 document types, and I want to be able to choose the Division, then the DocType; and any combination of these two produces a unique [DocPrefix] ID number. I want the user to choose the [Division], then the [DocType], and automatically return the ID number that is in the spreadsheet associated to each combination.
Any help?
It is a dependent dropdown but you are trying to make it a ref. Use a formula like SELECT(Document[DocPrefix], AND([DocType]=[_Thisrow].[DocType], [Division]=[_Thisrow].[Division]))
User | Count |
---|---|
27 | |
26 | |
22 | |
21 | |
21 |