{"id":92078,"date":"2025-07-31T16:20:00","date_gmt":"2025-07-31T20:20:00","guid":{"rendered":"https:\/\/bugaluu.com\/sapiosexual\/query-function-google-docs-editors-help\/"},"modified":"2025-07-31T16:20:00","modified_gmt":"2025-07-31T20:20:00","slug":"query-function-google-docs-editors-help","status":"publish","type":"post","link":"https:\/\/bugaluu.com\/sapiosexual\/query-function-google-docs-editors-help\/","title":{"rendered":"QUERY function &#8211; Google Docs Editors Help"},"content":{"rendered":"<p>QUERY(A2:E6,F2,FALSE) Syntax. QUERY(data, query, [headers]) data &#8211; The range of cells to perform the query on. Each column of data can only hold boolean, numeric (including date\/time types) or string values. In case of mixed data types in a single column, the majority data type determines the data type of the column for query purposes.<\/p>\n<p><a href=\"https:\/\/support.google.com\/docs\/answer\/3093343?hl=en\" target=\"_blank\" class=\"\">https:\/\/support.google.com\/docs\/answer\/3093343?hl=en<\/a>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>QUERY(A2:E6,F2,FALSE) Syntax. QUERY(data, query, [headers]) data &#8211; The range of cells to perform the query on. Each column of data can only hold boolean, numeric&#8230;<\/p>\n","protected":false},"author":0,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-92078","post","type-post","status-publish","format-standard","hentry","category-sapiosexual","wpcat-1-id"],"_links":{"self":[{"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/posts\/92078","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/comments?post=92078"}],"version-history":[{"count":0,"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/posts\/92078\/revisions"}],"wp:attachment":[{"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/media?parent=92078"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/categories?post=92078"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bugaluu.com\/sapiosexual\/wp-json\/wp\/v2\/tags?post=92078"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}