FLINT TABLE FILTER · HOW-TO
Fix number and date filtering when formats are ambiguous
09/11/2026 is 9 November in one office and 11 September in another. 1.250 is one and a quarter in one locale and twelve hundred fifty in another. Tell the table which you mean before you filter, sort or total.
What you will end with: the Received column read as day-first dates, so a 1 to 15 November range matches 4 samples, and the Weight column read with comma decimals, so its total is 2,271.25 g from 8 readable cells instead of 3.25 g from 2.
How the app detects types
- Number when every non-blank cell reads as a dot-decimal number. Thousands separators must group three digits; $, €, £ and % are allowed.
- Date when every non-blank cell is a YYYY-MM-DD date. Native Confluence date chips read as YYYY-MM-DD.
- Text otherwise. Day-first or month-first text dates and comma decimals are never detected automatically.
In the sample, Received and Weight (g) are detected as Text, and Cost as Number.
Sample measurements: mixed-formats.csv · 10 rows, 5 columns, fictional data.
| Sample | Received | Weight (g) | Cost | Notes |
|---|---|---|---|---|
| S-01 | 2026-11-03 | 1,5 | $1,234.50 | ISO date |
| S-02 | 09/11/2026 | 12,75 | $89.00 | Day first: 9 November |
| S-03 | 28/10/2026 | 0,8 | $310.25 | Day first: 28 October |
| S-04 | 11/12/2026 | 1.250 | $45.10 | Day first: 11 December |
| S-05 | 2026-11-14 | 2 | $1,005.00 | ISO date |
| S-06 | (blank) | (blank) | (blank) | Not received |
| S-07 | TBC | n/a | $62.40 | Placeholder text |
| S-08 | 31/11/2026 | 3,25 | $18.00 | Impossible date |
| S-09 | 05/11/2026 | 1.000,5 | $740.00 | Day first: 5 November |
| S-10 | 2026-10-30 | 0,45 | $9.99 | ISO date |
Dates: choose the format before filtering
- Choose Filters, then Received.
- Set Treat column as to Date and Date format in table to DD/MM/YYYY.
- Set Condition to Between, then enter
2026-11-01and2026-11-15in From (inclusive) and To (inclusive). Values can be typed as YYYY-MM-DD or in the selected format.
The same range gives different answers depending on the format you choose:
| Date format in table | Samples between 1 and 15 November |
|---|---|
| YYYY-MM-DD | S-01, S-05 |
| DD/MM/YYYY | S-01, S-02, S-05, S-09 |
| MM/DD/YYYY | S-01, S-04, S-05 |
| Sample | Received | Read as DD/MM/YYYY | Read as MM/DD/YYYY |
|---|---|---|---|
| S-01 | 2026-11-03 | 3 Nov 2026 | 3 Nov 2026 |
| S-02 | 09/11/2026 | 9 Nov 2026 | 11 Sep 2026 |
| S-03 | 28/10/2026 | 28 Oct 2026 | Not a date |
| S-04 | 11/12/2026 | 11 Dec 2026 | 12 Nov 2026 |
| S-05 | 2026-11-14 | 14 Nov 2026 | 14 Nov 2026 |
| S-06 | (blank) | (blank) | (blank) |
| S-07 | TBC | Not a date | Not a date |
| S-08 | 31/11/2026 | Not a date | Not a date |
| S-09 | 05/11/2026 | 5 Nov 2026 | 11 May 2026 |
| S-10 | 2026-10-30 | 30 Oct 2026 | 30 Oct 2026 |
YYYY-MM-DD values read the same under every setting. Cells that are not valid dates, such as TBC or 31 November, never match a date condition.
Sorting
Sort Received ascending after setting DD/MM/YYYY: S-03, S-10, S-01, S-09, S-02, S-05, S-04, S-08, S-07, S-06. Valid dates come first in date order, then cells that are not dates, and blank cells stay at the bottom in either direction. Left as Text, the same sort compares characters: S-09, S-02, S-04, S-03, S-08, S-10, S-01, S-05, S-07, S-06, which puts 5 November before 28 October.
Numbers: choose dot or comma decimals
Choose Weight (g) in Filters, set Treat column as to Number, and choose Number format in table and values. The format applies to cells and to the values you type, to sorting and to numeric summaries.
| Weight (g) cell | 1,234.56 (dot decimal) | 1.234,56 (comma decimal) |
|---|---|---|
| 1,5 | Unreadable | 1.5 |
| 12,75 | Unreadable | 12.75 |
| 0,8 | Unreadable | 0.8 |
| 1.250 | 1.25 | 1250 |
| 2 | 2 | 2 |
| (blank) | (blank) | (blank) |
| n/a | Unreadable | Unreadable |
| 3,25 | Unreadable | 3.25 |
| 1.000,5 | Unreadable | 1000.5 |
| 0,45 | Unreadable | 0.45 |
With comma decimals, Weight At least 1 matches 6 samples (S-01, S-02, S-04, S-05, S-08, S-09); with dot decimals only S-04 and S-05 match. A tag above the table, Comma decimals: “Weight (g)”, reminds readers which format is active. Type filter values in the same format: with comma decimals, enter 1,5, not 1.5.
Totals
Choose Summary, set Summarize column to Weight (g) and Summary number format to 1.234,56 (comma decimal):
| Summary number format | Sum | Cells counted |
|---|---|---|
| 1.234,56 (comma decimal) | 2,271.25 | 8 numeric · 1 blank · 1 unreadable |
| 1,234.56 (dot decimal) | 3.25 | 2 numeric · 1 blank · 7 unreadable |
Totals display in your browser’s number format. Blank and unreadable cells are excluded, and the counts show how many were left out, so an unexpectedly small total is easy to spot. The Cost column, detected as Number, totals 3,514.24 from 9 cells.
Relative dates use the device calendar
Relative presets compare against a reference date shown under the condition, for example Reference date: 2026-11-09 (your device’s local calendar). On that date:
| Preset | Matches dates from | To |
|---|---|---|
| Today | 2026-11-09 | 2026-11-09 |
| Yesterday | 2026-11-08 | 2026-11-08 |
| Tomorrow | 2026-11-10 | 2026-11-10 |
| Last 7 days | 2026-11-03 | 2026-11-09 |
| Next 7 days | 2026-11-09 | 2026-11-15 |
| This week | 2026-11-09 | 2026-11-15 |
| This month | 2026-11-01 | 2026-11-30 |
Last and next day windows include today, weeks run Monday through Sunday, and Last N days and Next N days accept 1 to 3650. Readers in different time zones can be on different calendar days.
Messages you may see
Invalid values appear under Check your filter values, and that condition matches no rows until corrected:
- Enter a valid number. For example,
1,5in a dot-decimal column. - Enter a valid date as YYYY-MM-DD or in the selected date format.
- The lower bound must not exceed the upper bound.
Publish the right formats
An author can store number formats for every reader in Default numeric columns, one exact header per line, such as Weight (g) = comma. Date formats are chosen per default filter in its date format in table and values setting. The most reliable fix is in the source: use native date chips or YYYY-MM-DD, and one decimal style per column.