Help

Re: Is there a way to sort chronologically?

Solved
Jump to Solution
5758 0
cancel
Showing results for 
Search instead for 
Did you mean: 
erlend_sh
4 - Data Explorer
4 - Data Explorer

I see that I can sort by 1 -> 9 or A -> Z, but is there a way to sort chronologically?

15 Replies 15

That’s not what I get when I sort by date at all.

When I sort by a “Date” field by 1 -> 9:
image

I get appropriate sorting by Year, Month, Day:
image

Aaron_Linsdau
4 - Data Explorer
4 - Data Explorer

Yes, you can sort by date. This was killing me, too. Set your date format to:
ISO (2019-01-22), that’ll make the sort work properly. Then you can autonumber if you need to enforce a sort by item added.

RommelParas
4 - Data Explorer
4 - Data Explorer

But it doesn’t work the same for pivot tables and charts

Katelynn_Straw1
5 - Automation Enthusiast
5 - Automation Enthusiast

I’m trying to sort by date as pictured below and it’s clearly not working. What am I doing wrong? The numbers don’t change whether I do 1-9 or 9-1…airtable

Hi Katelynn – sorry if we don’t make this clearer.

On grouped views, the Sort menu affects the order of records within a grouping, and not the order of the groupings themselves. You can change the order of the groupings from the Group menu (in this case, the grouped field is a linked record field, and in turn cannot be sorted by date).

I might recommend grouping first by the Due date field, and then by the Customer field. Or you can just as well sort by the Due date field and then by the Customer field.

Hope this helps a bit.

I removed the grouping, then sorted by in home dates and then re grouped by customer which gave me the result I was looking for.

Hopefully this continues to work as I add to the table!

Thanks for your assistance!