At your skill level (and mine!!), I would dumb this down.
Make a native checkbox formula field in QuickBase. Use that single field in your regular filter (not advanced query).
But if you want to learn the syntax others in this forum will have to wade in or you will need to research the help if it exists. Or the QuickBase Junkie may have courseware.