view to Group by individual selections in EnumList

[BobSig]

I want to be able to create a view, for all members to see, listing each Team Member and Tasks to which they are assigned.  My Team Tasks table has a column named Task Assigned To, which is an EnumList referencing a Mission Team Active slice.  The Team Task table allows me to add several Team Members to a task.  All of this works well.  Now I would like to create a view Grouping the Tasks by each individual user.  This way all users can see each member and the tasks to which they are assigned.  I have tried adding a virtual column, Individual Member, to the Task table and adding a Split expression attempting to split the Enumlist selections into individual items.  This did not work.

Is there another expression or method I can us to accomplish this?

[jballester]

Hi, 

Control grouping in a view could be useful to you. Perform a grouping by [Task Assigned To].
https://support.google.com/appsheet/answer/10106698

 

 

[BobSig]

Thanks, but that will not help. The column I want to sort by is an
Enumlist. It may have several members selected for a task. I want to break
this list of assigned users apart and group the tasks by each individual
member. In this View all Team Members will see a list of Members and the
tasks assigned to them.

[jballester]

I'm sorry, my first answer wasn't adequate.
The standard design would be, projects (one), tasks (multiple), and users (one), or orders (one), order details (multiple), and products (one). Combining projects and tasks, or orders and details, in the same table (one and multiple) to then want to obtain lists is somewhat complex for me.
I've reviewed my documentation, and you need a table to be able to use groupings. The solution I'm providing requires some attention, but the possibilities it has are fantastic. Steve's post includes an example app.

Looping · Add one row per value in an EnumList column list.
https://www.googlecloudcommunity.com/gc/Tips-Tricks/FAQ-add-row-per-value-in-EnumList/m-p/748860

[BobSig]

Thanks. I will give it a try. I was hoping for an easier method, but ….

[BobSig · Accepted solution]

Thanks for the tip.  I read further down the link posted and used the updated version by MODE.  

It took me a while to get my expression working correctly, but, finally made it.  I also set the actions to be activated in a BOT whenever there was a ADD or UPDATE to the Control TABLE.