Forum Discussion
JoshKlein
Dec 17, 2020Copper Contributor
How can I filter a table based upon options in a worksheet?
Let's say I have a task list of items that need to be accomplished Description Tasks D1 T1 D2 T2 D3 T3 D4 T4 Each of these tasks really only needs to be don...
SergeiBaklan
Dec 17, 2020Diamond Contributor
If you have two tables, Tasks and Conditions
you may filter the content with
=FILTER(Tasks,MMULT(--(Tasks[[Condition1]:[Condition3]]=TRUE),--(Conditions[State]=TRUE)))