Is it possible to create a formula that filters a list of values in a helper table by a column value in the original filtered table?
*“Helper table” = a table that contains a list of filtered values from another table
I have a table with all the raw data (“Schedule”). It contains lookup columns from helper tables (different categories for the data).
The helper tables have a column with a filter formula for the rows from the schedule table.
I also have another table that is used as a dashboard and data analysis tool: “Analysis by Operator and Type”. It has a single row.
Right now I’m filtering the data in the analysis table from the schedule table directly:
What I really need is to get the data from the helper tables, and filter out the some of the values inside the column containing the list of values from the schedule table.
In Analysis table I choose “Stream”: “Live” in the Stream select list column.
The “Genre” column will then propagate with the genre rows from the “Genre” table. The 2nd column in the Genre table is “Show” - a list of filtered rows from the raw data (“Schedule”) table.
So the “Genre” column in the Analysis table will get the info from the Genre table, including only shows that their “Stream” tag is “Live”.
Here’s the test table for reference
Thank you for all helpers