Is it possible to use an array or list (that is within a single cell) as a condition in a filter formula?
Here is my example:
In Tabale2.Column1 in each row I have different arrays/lists of items selected manually from Table1.Column1
For Table2.Column2 I’m looking for a column formula that filters Table1 based on the selection and SUM the filtered Table1.Column2 values.
I’ve tried the CONTAINS formula but it doesn’t seem to work this way:
=[Table 1].filter(Contains([Table 2].[Column 1],[Column 1])).[Column 2].sum()
Did I just miss something or there’s another totally different way to achieve this result?
Thanks a lot!