lundi 2 décembre 2019

How to add a WHERE function to a complex string

I am trying to only query data that has a number > 0 in Column K within this complex string.

=QUERY('Form Responses 1'!A1:K,"SELECT *" & if(COUNTBLANK('Helper Formulas'!A1:A3)=3,""," WHERE " & TEXTJOIN(" AND ",TRUE,'Helper Formulas'!A1:A3)),1)

I tried...

=QUERY('Form Responses 1'!A1:K,"SELECT * WHERE K > 0" & if(COUNTBLANK('Helper Formulas'!A1:A3)=3,""," WHERE " & TEXTJOIN(" AND ",TRUE,'Helper Formulas'!A1:A3)),1)

But keep getting an error.

Not sure what I need to do.

Aucun commentaire:

Enregistrer un commentaire