Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Incorrect sorting records

Topic Labels: Views
310 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Can anyone please help me?
Sorting of records by creation date is enabled in the table. Further, the records are grouped by a common feature date range.
But the records are not sorted correctly, look at the picture.
What have I done wrong?
Снимок экрана 2021-05-17 в 18.46.41
Снимок экрана 2021-05-17 в 18.47.12

2 Replies 2

Welcome to the Airtable community!

Your table includes both grouping and sorting.

Airtable first groups records, and the groups are ordered according to the direction specified for the group. Airtable is grouping by the {Week of the Year}, and it is sorting that group alphanumerically, not according to date. Thus “07” appears before “10”, which is before “17”. Because the {Week of the Year} lists the week as day-month-year, it will not sort chronologically. To make the alphanumeric sort match the chronological sort, have the formula present the date in YYYY.MM.DD format.

The sort setting in your screen capture applies to records within a group. It does not apply to records across groups, Thus this sort only applies when there are multiple records in the same week. You can see that the week of 17-05-2021, has two records and they are correctly sorted in regard to each other.

Thank you very much for the detailed explanation.