I am having trouble creating a query to pull only TRUE values from two specified columns. On the Data tab I only want data to populate in the query if either columns 10 or 11 contain TRUE values. For some reason the query is pulling data that contains no True values in columns 10 or 11. The query also seems to only be reading values in column 10 and not column ll. If a user (Rep A or Rep B) selects a true value on in column 10 or 11 (checks box) I want those companies to populate on the Data tab.
Not sure what to try. Copy of workbook shared below.
https://docs.google.com/spreadsheets/d/14CxxGfL1XJX0hMH4G6N8Ghm6m1cHtYx-gfbL2tiJOOU/edit?usp=sharing
Aucun commentaire:
Enregistrer un commentaire