Home > OS >  If/Filter clause to query formula (with arrayformula embeded)
If/Filter clause to query formula (with arrayformula embeded)

Time:07-08

I have a response sheet on GSheets with over 100 columns/questions that can either be responded by Yes or No. If the candidate answers no they will have to fill in a freetext question.

The following formula - allows me to export the questions that were answered Yes or No from one sheet to another:

=QUERY('Module 1 Responses'!$A$2:$AS,"SELECT "&join(",",arrayformula(SUBSTITUTE(ADDRESS(1,MATCH($A$1:$W$1,'Module 1 Responses'!$A$1:$AS$1,0),4),1,""))))

I would like to add an "if" or a "filter" clause to this formula so that I can only see the "No"s or that would convert all the "Yes" values to blank - if at all possible

Please see sheet with mock data here: enter image description here

  • Related