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?

1 Answer 1


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? Commented Feb 27, 2016 at 0:43
  • Please post a new question with the corresponding details. Commented Feb 27, 2016 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? Commented Feb 27, 2016 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
    Commented Mar 1, 2016 at 9:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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