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.
User | Count |
---|---|
44 | |
35 | |
25 | |
24 | |
15 |