samedi 20 juin 2020

Is possible to use a QUERY() inside of SWITCH()?

I am doing a spreadsheet in Google Sheets and one of my formulas is full of “if”, so I tried to use a switch instead. The problem is, I need the output to be a query but I only get the first cell of my query. I don’t know if it’s because I can’t use a query in switch or if I am making a syntax mistake. I would really appreciate the help.

=switch(A1, “car”, query(‘Other Sheet’!B1:B, “select * where B > 10”))

Aucun commentaire:

Enregistrer un commentaire