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