Finditem in Subset
Is there a function that will return whether a list item is a member of a subset? I can't figure out how to get FINDITEM to return a value.
Example: I have a list of accounts segmented into three subsets, Group A, B, and C. Each account group has its own set of managers and assignment logic, so subsets are ideal. However, when presenting an overall account assignment matrix to sales leaders, I want to provide a line item called "Account Type" that gives them the ability to filter on which subset the account is a member of. There wouldn't be any overlap between the subsets, but would the potential of that would make this infeasible? I was thinking I could use something like ISNOTBLANK(FINDITEM('List Subset', Account Name)) as a Boolean to determine yes/no present in the subset, then have a separate line item referencing that Boolean to say which category the account falls into.