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.
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.