I'm not sure what is happening in my Google Sheet query and could really use some help. I have a quick screencast that demonstrates and explains the issue.
Basically, I'm using a query to pull data from a Google Spreadsheet that is populated by a Google Form. If the form submits only numbers (100), there is no problem. However, if someone submits a string ($100 or 100 dollars), the query will not display the string. It will only display form submissions that are 100% numbers.
Also, if the 1st submission is a string (not 100% numbers) the query will work.
Here is my query
=query(data!B2:CL,"select B, C, D, E, F, G, H, I, J, CI, BZ, CA, BA where J = 'Industry Certification'",false)
Any ideas on why this is happening?
Also, I'm aware that I can limit the form to numbers only. I'm trying to avoid that and learn 'why' this is happening.