I'm trying to get a query based on a tri-state. The possible values are TRUE, FALSE, 'Ignore' or blank. I want this to select all names (B) and emails (C) where a flag column is set to False or blank.
=QUERY(Roster!B3:T, "SELECT B,C WHERE M<>TRUE AND M<>'IGNORE'")
I've also tried
=QUERY(Roster!B3:T, "SELECT B,C WHERE M=FALSE OR M=''")
=QUERY(Roster!B3:T, "SELECT B,C WHERE M=FALSE OR M IS NULL")
but none gives me all the people who don't have TRUE or Ignore, and do have FALSE or blank.
Is there a way to actually do TRUE/FALSE/OTHER column query conditions, or is this an impossible task?