I'm trying to copy data from Sheet A to Sheet B based on if one of the columns has True or False. I'm trying to use:  =QUERY( 'A'!A1:I200 , select * where I = 'True' )but this only gives me the header row. How can I get it to copy all rows that contain True?
Query to copy from Sheet A to B based on true/false
google spreadsheets;google drive