Filter formula for 2 tables sharing look up column

1

I’m trying to connect two tables. First table is a quick survey with 1 row for each job. The second is a list of improvement opportunities with multiple rows for each job. They both use a look up column from a 3rd table with a list of all the jobs. I want to create a summary of all the improvement opportunities in the 1st survey table.

I made a test document. Here’s a link

I can’t get it to work. I’m wondering if the problem is that I’m trying to match two columns that are both lookup columns. Any suggestions?

2

Hi @Jack_Spellman - can you try this formula and see if it is what you are looking for
= [Improvement Opportunity].Filter(Job=thisRow.Job).Note.BulletedList()

1 Like
3

That did the trick. Thanks so much!

1 Like