Hi, I have this problem that I have been trying to resolve with different syntax and functions but I am not getting anywhere.
Basically I have this expression within Valid If:
SELECT(
Auditor Technical Codes[Auditor ID],
CONTAINS([Client Technical Codes], [Technical Code Approval]),
)
It half works. It shows me a list of Approved Auditors (Auditor ID) where they have a technical code approval that matches the client technical code for the record. However, it is showing me auditors who have at least one of the codes, not all of them.
A bit more context. I am within a client record, the client record has a number of codes that are applicable to that client; I will use Q01, Q02 as an example. These are applied to the client record using an Enumlist.
I have a ref column (which is the one I have this valid if statement within), this reference goes to my list of auditors. The list of auditors is relatively long and it has a column for the technical code they are approved for like below:
Auditor 1-Q01
Auditor 2-Q02
Auditor 3-Q01
Auditor 1-Q02
I want Auditor 1 to be the only auditor shown on the reference as they have both codes (Q01 and Q02), at the moment it will show all three auditors as they all have at least one of those codes.
I hope that is clear, tried to get it right but I'm always getting errors no matter what I am trying
LinkedIn
Twitter
