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?