Multi-user Task Manager Summary Report by User

Question

I have a task manager in which I can assign multiple user to a single task via the [Assigned To] List-user field. So far I have not been able to make a summary report which breaks down the task assignment by individual users.

For example, Bob, Mike and Jan can be assigned tasks. Bob and Mike are both assigned individual tasks, but Mike and Jan are both assigned to work another task together.

Currently the summary looks like this:

Assigned To # of Tasks
Bob 1
Mike 1
Jan, Mike 1

I want it to look like this:

Assigned To # of Tasks
Bob 1
Mike 2
Jan 1

The problem I keep running into is not being able to summarize records that contain multiple values in a single field. Anyone have any creative solutions? My Project Manager sure would like to see the total amount of tasking assigned to each user at a glance.

------------------------------
David Browne
------------------------------

MarkShnierYou · Answer

The only way i can think to do this would be to use an Automation to maintain a child table of the individual Assignees. The Assignment record would need to have formula fields to parse out say the first 10 assignees fomr the LIst User field and then the Automation would fire when the Assignment record was added or edited. The Automation would delete all the children, then create the 10 Child records and then delete any blank ones with no Assignee.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------

Sign up

Login to the community