Project Tasks lists are very useful for managing tasks to track progress among team members. Especially Managers love this feature.
We usually setup views to show only items assigned to self and it works well. But Managers have special views which shows all the items assigned to the team. When one user who is Manager tried to filter the list based on ‘Assigned To’ field an error message popped up saying ‘Cannot show the value of the filter. The field may not be filterable, or the number of items returned exceeds the list view threshold enforced by the administrator.’
Well, being the administrator am pretty sure that this list did not exceed the list view threshold. I’m also sure that we can filter the ‘Person’ field.
First thing I tried is to index the ‘Assigned To’ column, which I could not. I did not find a way to index this ‘Assigned To’ column. Then, I looked at the properties of this field, and found out that ‘Allow selection of:’ value is set to ‘People and Groups’. This clearly is the problem here. When you set this field to allow selection of either people or groups, it cannot be filtered. I changed it back to ‘People Only’ and was able to filter. When you create this list from template, these values are preset to default.
Resolution: Set the ‘Allow selection of:’ property for ‘Assigned To’ field to ‘People Only‘.
Also make sure that ‘Show field‘ is set to ‘Name (with presence)’.
Hope it helps someone!