Outputting all related

Hi! Here is the the page for reference.

I have a support table of teams and their product area.

I have another table (table 1) where I assign teams to projects in one column and a “Affected Product Areas” in another column. I tried my hand at writing a formula for the “Affected Product Areas” but it’s throwing an error. How can I get rid of this error? All downstream equations work but the error is preventing me from filtering. Thanks!

I added a column to your table with a formula that does what I think you want to accomplish.

1 Like

and just like magic, you fixed it. thank you @joost_mineur ! :D. i really appreciate your help!

My way: thisRow.Teams.ForEach(thisRow.Teams.Filter(Name=CurrentValue.ToText()).[Product Area])

Solution: Teams.Filter(CurrentValue.In(thisRow.Teams)).[Product Area]

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.