FLINT TABLE FILTER · HOW-TO
Combine AND/OR filters for questions a simple dropdown cannot answer
Column filters answer “this and that.” Some questions need “this and (that or the other).” Advanced groups let you write that expression directly, nest it, and publish it as the page’s starting view.
What you will end with: Engineering AND (Blocked OR due this week) returning 5 of 24 tasks, a nested version that adds an estimate threshold and returns 4, and the expression published as the table’s default.
Why separate column filters fall short
In the column filters, several values chosen for one column match any of them, and filters on different columns must all match. Choosing Team Engineering, Status Blocked and Due This week therefore asks for Engineering tasks that are blocked and due this week. In the sample tracker, none are. The question is really Engineering AND (Blocked OR due this week).
Sample tracker: project-tracker.csv · 24 rows, 7 columns, fictional data.
| Task ID | Task | Team | Owner | Status | Due | Estimate |
|---|---|---|---|---|---|---|
| PRJ-101 | Checkout API timeout fix | Engineering | Priya Shah | Blocked | 2026-11-06 | 3 |
| PRJ-102 | Billing page redesign | Design | Mateo Ruiz | In progress | 2026-11-12 | 5 |
| PRJ-103 | Release notes draft | Docs | Hana Sato | To do | 2026-11-13 | 2 |
| PRJ-104 | Search index migration | Engineering | Liam O'Neill | In progress | 2026-11-10 | 8 |
Show all 24 rows
| Task ID | Task | Team | Owner | Status | Due | Estimate |
|---|---|---|---|---|---|---|
| PRJ-101 | Checkout API timeout fix | Engineering | Priya Shah | Blocked | 2026-11-06 | 3 |
| PRJ-102 | Billing page redesign | Design | Mateo Ruiz | In progress | 2026-11-12 | 5 |
| PRJ-103 | Release notes draft | Docs | Hana Sato | To do | 2026-11-13 | 2 |
| PRJ-104 | Search index migration | Engineering | Liam O'Neill | In progress | 2026-11-10 | 8 |
| PRJ-105 | Help center screenshots | Docs | Hana Sato | Done | 2026-11-04 | 1 |
| PRJ-106 | Support macro update | Support | Ama Mensah | In review | 2026-11-11 | 1 |
| PRJ-107 | Launch email copy | Marketing | Jonas Berg | In progress | 2026-11-20 | 2 |
| PRJ-108 | Accessibility fixes | Design | Mateo Ruiz | Blocked | 2026-11-18 | 4 |
| PRJ-109 | Rate limit alerts | Engineering | Priya Shah | To do | 2026-11-14 | 3 |
| PRJ-110 | Escalation runbook | Support | Ama Mensah | In progress | 2026-11-27 | 2 |
| PRJ-111 | Pricing FAQ | Docs | Lena Fischer | In review | 2026-11-09 | 1 |
| PRJ-112 | Webhook retry policy | Engineering | Liam O'Neill | Blocked | 2026-11-24 | 5 |
| PRJ-113 | Customer webinar plan | Marketing | Jonas Berg | To do | 2026-12-02 | 3 |
| PRJ-114 | Status page wording | Support | Ama Mensah | Done | 2026-11-05 | 1 |
| PRJ-115 | Mobile layout review | Design | Noor Haddad | To do | 2026-11-15 | 2 |
| PRJ-116 | Data export test plan | Engineering | Priya Shah | In review | 2026-11-12 | 2 |
| PRJ-117 | Partner briefing deck | Marketing | Jonas Berg | Blocked | 2026-11-13 | 2 |
| PRJ-118 | API changelog | Docs | Lena Fischer | To do | 2026-11-19 | 1 |
| PRJ-119 | Trial onboarding emails | Marketing | Sofia Costa | In progress | 2026-11-16 | 3 |
| PRJ-120 | Dependency upgrades | Engineering | Liam O'Neill | To do | 2026-11-23 | 5 |
| PRJ-121 | Ticket tag cleanup | Support | Tomás Silva | To do | 2026-11-17 | 1 |
| PRJ-122 | Icon refresh | Design | Noor Haddad | Done | 2026-11-02 | 2 |
| PRJ-123 | Backup restore drill | Engineering | Priya Shah | To do | 2026-11-30 | 3 |
| PRJ-124 | Glossary update | Docs | Hana Sato | In progress | 2026-11-26 | 1 |
The worked examples use Monday 9 November 2026 as today. Relative date presets follow each reader’s device calendar, so on another day the same rule matches different rows. Where it matters, a fixed date range that reproduces the published result is included.
How advanced groups combine
- Match groups joins the top-level groups: All groups (AND) or Any group (OR).
- Each group has its own Match rules in group setting: All rules (AND) or Any rule (OR). Nested groups keep their own choice too.
- Search and column filters still apply alongside the advanced groups; all must match.
Step 1: Build Engineering AND (Blocked OR due this week)
- Choose Filters, then Advanced groups. Keep Match groups as All groups (AND).
- Choose Add group. Set Rule column to Team, Rule condition to Equals and Rule value to
Engineering. Choose Save rule. This is group 1. - Choose Add group again. Create Status, Equals,
Blockedand save it. This is group 2. - Set Match rules in group 2 to Any rule (OR).
- Choose Add rule to group 2. Set Rule column to Due, Rule condition to Relative date and Rule date preset to This week. Save the rule.
The panel shows each group with its match setting and numbered rules. In outline:
Group 1 Match rules in group 1: All rules (AND)
1.1. Team equals Engineering (Text)
Group 2 Match rules in group 2: Any rule (OR)
2.1. Status equals Blocked (Text)
2.2. Due: This week (Date, YYYY-MM-DD)Choose Done. The count line reads 5 of 24 rows; sorted by Due:
| Task ID | Task | Owner | Status | Due | Estimate |
|---|---|---|---|---|---|
| PRJ-101 | Checkout API timeout fix | Priya Shah | Blocked | 2026-11-06 | 3 |
| PRJ-104 | Search index migration | Liam O'Neill | In progress | 2026-11-10 | 8 |
| PRJ-116 | Data export test plan | Priya Shah | In review | 2026-11-12 | 2 |
| PRJ-109 | Rate limit alerts | Priya Shah | To do | 2026-11-14 | 3 |
| PRJ-112 | Webhook retry policy | Liam O'Neill | Blocked | 2026-11-24 | 5 |
Switch Match groups to Any group (OR) to see the difference: every Engineering task plus anything blocked or due this week, 14 rows in all. Switch back before continuing.
Step 2: Nest a third level
Suppose the meeting only cares about this week’s work if it is estimated at three days or more: Engineering AND (Blocked OR (due this week AND Estimate at least 3)).
- Choose Remove rule 2.2 to remove the plain due-this-week rule.
- Choose Add nested group to group 2. Create Due, Relative date, This week and save it. The nested group is group 2.2 and starts as All rules (AND).
- Choose Add rule to group 2.2. Set Rule column to Estimate, keep Rule type as Number, set Rule condition to At least and Rule value to
3. Save the rule.
| Task ID | Task | Status | Due | Estimate |
|---|---|---|---|---|
| PRJ-101 | Checkout API timeout fix | Blocked | 2026-11-06 | 3 |
| PRJ-104 | Search index migration | In progress | 2026-11-10 | 8 |
| PRJ-109 | Rate limit alerts | To do | 2026-11-14 | 3 |
| PRJ-112 | Webhook retry policy | Blocked | 2026-11-24 | 5 |
PRJ-116 drops out: it is due this week but estimated at 2 days. The blocked tasks stay regardless of estimate.
Step 3: Publish it as the starting view
- Choose Copy advanced filter settings. Copy everything in Advanced filter settings.
- Edit the page, open the macro settings, choose Column filters and advanced rules and paste into Default advanced filter groups.
- Starting view preview counts the matches. For the Step 1 expression it reports 5 of 24 rows match. Choose Save settings and publish.
Only the applied advanced groups are copied; search, column filters, sorting and layout are separate settings. The copied text names columns by header and stores relative presets, not dates:
Show the copied settings for the Step 1 expression
{
"version": 1,
"match": "all",
"groups": [
{
"match": "all",
"rules": [
{
"header": "Team",
"condition": {
"type": "text",
"dateFormat": "iso",
"operator": "equals",
"value": "Engineering",
"valueTo": "",
"preset": ""
}
}
]
},
{
"match": "any",
"rules": [
{
"header": "Status",
"condition": {
"type": "text",
"dateFormat": "iso",
"operator": "equals",
"value": "Blocked",
"valueTo": "",
"preset": ""
}
},
{
"header": "Due",
"condition": {
"type": "date",
"dateFormat": "iso",
"operator": "relative",
"value": "",
"valueTo": "",
"preset": "thisWeek"
}
}
]
}
]
}If a header named in the settings is later renamed, readers see Check the table's default view, and the advanced default is skipped rather than partly applied. Build the rule again and copy fresh settings.
Limits and behavior
- Up to 5 top-level groups and 5 rules or nested groups in each group, nested up to four levels, with at most 100 groups and rules in total.
- A draft applies only after Save rule. If you leave the panel with a draft open, the toolbar shows An advanced rule has unsaved changes. with Continue editing rule.
- Each rule keeps its own type and format. A number rule has Rule number format; a date rule has Rule date format.
- If any rule is invalid, the warning Check your advanced filters names it, and the whole expression matches no rows until you fix it. It never applies half an expression.