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 cannot seem to figure out why I continue to receive #VALUE! error. my goal is to have the filter return just the project No. (column 1) and days left to expiration, if between 0 and 30 days (column 14)
Any help is appreciated.
3 Replies
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
