filterfunction - How to combine Filter and IF-Statements in Google Spreadsheet -
problem have 2 sheets.
- sheet 1: supposed contain dashboard.
- sheet 2: contains table 3 columns, starting @ row 16
so want
- type in string in 'sheet 1'!$b$2, have formular value in sheet 2, , return 3 columns.
- if 'sheet 1'!$b$2 empty, show columns , rows of sheet
here tried: =if(isblank($b$2), 'sheet 2'!a16, filter('sheet 2'!a16:a$1000, 'sheet 2'!$c16:$c$1000=$b$1))
works trick nr. 1, not nr. 2. shows first row obviously.
if pull formular down rows, nr. 2 works, nr. 1 not. error gives me ref - array result not expanded, because override data in f16
. f16 column, formular in.
can advice?
for case formula this:
=if(isblank($b$1), arrayformula(sheet2!a16:d1000), filter(sheet2!a16:a$1000, sheet2!$c16:$c$1000=$b$1))
Comments
Post a Comment