Forum Discussion
Nesting a Filter formula within another Filter filter formula to only display certain data.
I am attempting to use a Filter within a Filter and only show specific columns using the formula attached. note the total columns in the table is 35, hence all the 1,0,0,0 etc. inside the {}. I cann...
Size of the array which is condition for the outer FILTER() shall be exactly the same as number of columns returned by inner FILTER(), i.e. 13 if I count correctly.
SergeiBaklan Thank you! it worked when I matched the number of columns per your comment.
ebruzgulis-work , so far so good, glad to help