Iโm trying to filter my suggested values to only show those handlers with Admin privileges. I have a separate sheet for users and their rank from before. I tried to merge the users and staff pages but everything broke.
if(AND([Handler Full Name]=โUsers[Full Name]โ, โUsers[Admin Level]โ=โAdminโ), [Handler Full name], โโ)
The expression is valid but its result type โNameโ is not one of the expected types: List
This is what it shows me now.
It was also telling me that the types of both results have to match? But I donโt want it to pull through any other values.
First
Users[Admin Level]=โAdminโ
would pull EVERY records value from the table (instead of a single users), instead try this:
Next, youโll want to check out the SELECT() formula - itโs what will allow you to build a list
โUsers[Full Name]โ
โwith quotes around it as you have itโis the literal text, Users[Full Name]
. It is NOT the value of the Full Name column as I expect you intend.
Further, Users[Full Name]
is a table-column reference, which produces a list of values. Comparing a singular value ([Handler Full Name]
) against a list of values does NOT search for the singular value in the list, as you may intend.
See also:
User | Count |
---|---|
44 | |
35 | |
25 | |
24 | |
15 |