Hi all i have a google sheet where in sheet B C D E data gets enterd and exported to sheet E via query.
but it sorts it per sheet and not mix them in order.
i dont want a Date order of sheet B then sheet C,
i need it that 1-1-23 on sheet D is in front of 31-12-2022 from sheet B
this is the query formula i use now
=QUERY({SheetB!A2:N;SheetC!A2:N;SheetD!A4:N;SheetE!A5:N},"select * where Col1 is not null",0)
Col1 is the column with the dates in it witch need to be sorted
i stried sorting via the Sort A-Z method that is not working i also tried to add Sorty By Col1 as shown below
=QUERY({SheetB!A2:N;SheetC!A2:N;SheetD!A4:N;SheetE!A5:N},"select * where Col1 is not null",0,Sorty By Col1)
example sheet https://docs.google.com/spreadsheets/d/1gQUkJUW8ChWj59vtDu64rI1ozZjY6b5ABmzns6lgF9o/edit?usp=sharing
CodePudding user response:
try:
=QUERY({SheetB!A2:N;SheetC!A2:N;SheetD!A4:N;SheetE!A5:N},"select * where Col1 is not null ORDER BY Col1 DESC",0)