I’m trying to do a simple filter in a table and I’m having difficulties in understanding why it doesn’t work.
Here are 2 tables. One is a list of tickets, and for each we can assign an problem using a lookup to the second table.
The second table, the list of problems, compute how many tickets are assign per problem, and propose a solution.
I want the solution to be displayed in the first table with each ticket as well, so I thought I could just use a formula with a filter to find the row in list of problem that matches current rows problem, but i doesn’t work. It outputs every row instead.
The answer is probably very simple, but I’m stuck on this.
Thank you in advance for your help.