All Questions
2 questions
0
votes
1
answer
90
views
If/Filter clause to query formula (with arrayformula embeded)
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 ...
- 27
7
votes
1
answer
13k
views
How to query results that don't contain the #N/A error in Google Sheets
I am trying to query results that don't contain #N/A results from another sheet in the same Google Sheets WorkSheet.
I have tried this formula but it won't work
=QUERY('Table 1'!A2:G500, "Select F ...
user9258693