The driving force was the PM lead wanted to remove individuals from projects who had no work left to do on the project so they wouldn't receive notifications on the project anymore.   The roles would stay assigned but lets say a user has finished all their tasks and there are no tasks left with role...

I've been trying to get a list of project users that can be removed from the project who have completed all their tasks and their primary role has all the tasks associated with it completed as well.   So far I've only been able to make two columns that show the primary roles left with tasks on the p...