I have a sheet where I input my jobs booked. I want to be able to import information for the first 4 columns (Job Number, Job Name, Salesman, Date booked) if Column F (Permit Required) has a "Yes" in the drop down.
This is what I have: =QUERY(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1A4SRBoTA1md8YnIVkp87Ngo3Pk9gPpB8YW6BLIiRNy8/edit#gid=1613480212","bOOKINGS!A2:L1000"),"Select Job Number,Job Name,Salesman,Date Booked Where Permit Required (Y/N)= 'yes'")
I receive this error: #VALUE! Unable to parse query string for Function QUERY parameter 2: PARSE_ERROR: Encountered ' 'Number"" at line 1, Column 12. Was expecting one of: "where... "Group" ... "Pivot"...
In column M, on the sheet I'm importing from, I have my array for drop downs in Columns E-H.
Can I Please get assistance?