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.