Filter table - summarize values from multiple rows

bartek_polakowski

Hi,

I have a training report with a simple structure

User ID	Training title	Training status
User 1	Training 1	Completed
User 1	Training 2	Started
User 2	Training 4	Completed
User 3	Training 1	Completed
User 3	Training 2	Completed
User 3	Training 3	Completed

Now I need to somehow collect users who completed Training 1, 2, 3 and have a separate column for the saying that WHole curriculum is completed. Any hint?

afv2688

Hello @bartek_polakowski ,

Training names cannot be separated by commas on a contians condition, you would need to change the way you do it, you could either use join or a different solution, like a filter with "AND's"

Regards

completed trainings.yxmd