Re: Multi-user Task Manager Summary Report by User

The formula to parse out the first user form a List User field would be

ToUser(Part(ToText(UserListToEmails([Assignees])),1,";"))

The 2nd user would be

ToUser(Part(ToText(UserListToEmails([Assignees])),2,";"))

In my suggested setup the Assignment record would have a child table so that if the ListUser Assignees were Curly, Larry and Moe, then there would be three children records, one for each.  You would lookup ant info you needed from the Assignment record and then make your report off the child table of the individual assignees.




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