I hope I can ask this the right way. I have columns that describe different values, and I have created filters for different users to see specific rows with specific values. Each row represents a task. For instance, Person 1 sees tasks that have picked Values of X in one column and Y in another column. Person 2 would see tasks that have Values of A and B and Person 3 would see tasks with Values of P and Q.
How could I create a column that would show the number of tasks each person currently has in their filtered list? I can do a Lookup column with filters for Value A and B or X and Y or P and Q, but I can’t assign that column to be rollup or some other computing column. What would be the best way to create a counter that I could then place on each persons task list so that they could see how many tasks they currently have assigned?