When I perform a query to essentially filter a range of names, and times, any cell that is not a time gets blanked out. Screenshot of example:

enter image description here

I'm keeping this post fairly short since the image succinctly describes the problem. Whats causing this, and how do I correct it?


QUERY result assigns a data type to each column. The "blanked out cells" occurs because their data type is not compatible with the data type of the resulting column.

Instead of QUERY use FILTER.

To learn more about QUERY see https://support.google.com/docs/answer/3093343?hl=en and https://developers.google.com/chart/interactive/docs/querylanguage.

  • In this case, I'm querying an import range as a single formula. Can I filter an import range without having to import the range multiple times within the filter formula? – Douglas Gaskell Feb 27 '16 at 0:43
  • Please post a new question with the corresponding details. – Rubén Feb 27 '16 at 0:46
  • That seems like a waste, to post an identical question with the addition of a single sentence, barely changing the meaning of the question. Is your answer the only possible solution for the problem this question poses? If it isn't, then adding addition details would make sense wouldn't it? – Douglas Gaskell Feb 27 '16 at 2:43
  • 1
    A workaround would be never put any text in your original data. Instead, for "OFF", simply put a 0 value, and then use custom number formatting: h:m am/pm;;OFF;@ – daniel Mar 1 '16 at 9:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.