This is a Show if constraint for a view called “Test.” So, in this context, [Teamleaders] is incomprehensible. If the table name is “Test” I wonder if the following wouldn’t work:
In(USERMAIL(),Test[Teamleaders])
Here’s part of the explanation from the IN() page:
IN(USEREMAIL(), AppUsers[Email]) answers the question: is the current app user’s email address (USEREMAIl()) found in the list of Email addresses in the AppUsers table (AppUsers[Email])? See also: USEREMAIL().
This is a Show if constraint for a view called “Test.” So, in this context, [Teamleaders] is incomprehensible. If the table name is “Test” I wonder if the following wouldn’t work:
In(USERMAIL(),Test[Teamleaders])
Here’s part of the explanation from the IN() page:
IN(USEREMAIL(), AppUsers[Email]) answers the question: is the current app user’s email address (USEREMAIl()) found in the list of Email addresses in the AppUsers table (AppUsers[Email])? See also: USEREMAIL().
User | Count |
---|---|
41 | |
28 | |
28 | |
23 | |
13 |