I’m building a dashboard to track project work for specific individuals on my team. On our project board, we use “Assigned” to indicate who is working on a project, and we sometimes have more multiple employees assigned to a project.
On my dashboard, I’ve set a dashboard-wide filter to only include the employees I want to track (Where assigned is name, name, name) which in theory should only pull in data for those individuals on every project where they’re assigned.
However, it’s actually pulling in data for those who are co-assigned to the project as well, not just the indicated assignee.
So if 2 people are assigned to a project, 1 whom I want to track and 1 whom I don’t, the dashboard is pulling in both.
Does anyone know how to make Monday exclude the employees I haven’t indicated in the filter setting? Using “Where Assigned is not name, name, name” does not work, as it excludes the projects where there are co-assignments.
thanks!