Forum Discussion
Solved
VSTACK and SORT
I have a spreadsheet with many (27) sheets where all the columns in each sheet are the same. I have created a dashboard using VSTACK to show all the data from all the sheets on a single page. =VSTAC...
Did you try
=SORT(VSTACK(Table1, Table2, Table3....Table27), 7)
to sort on column G in ascending order, or
=SORT(VSTACK(Table1, Table2, Table3....Table27), 7, -1)
to sort on column G in descending order.
I have, and the column that I am trying to sort by does not appear in chronological order. It appears like the following.
9/27/2024
10/6/2024
10/6/2024
10/18/2024
10/15/2024
10/18/2024
10/18/2024
9/29/2024
9/27/2024
10/6/2024
10/6/2024
10/18/2024
10/15/2024
10/18/2024
10/18/2024
9/29/2024
Are these true date values or TEXT values looks like date? If they are true dates then it must works.
Harun24HR I have tried having the format type of the data be both "Short Date" and "General" Neither of those format types have yielded properly sorted data.