I know it's late but I ran into a similar issue and found that using column letters didn't work but using Col1, Col2 etc. did. Not very clearly documented.
Try: =QUERY(ResourceUsage2015!C4:F200, "select Col1 WHERE Col4 = 'Vacation'", -1) I also ran into a formatting issue using -1 header rows. I didn't include the headers in the data range and used 0 for this argument and it fixed it. Jay On Monday, 1 June 2015 23:43:28 UTC+2, R. K. Nair wrote: > > I am using the following query syntax in my google sheet. It doesn't show > any results even after modifying the query with 'contains', startswith etc. > > =QUERY(ResourceUsage2015!C4:F200, "select C WHERE F ='Vacation'", -1) > > Any idea why this is happening. I have plenty of data that matches this > criteria. > > Thanks. > > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
