How to invert the Google sheet row order into Glide

Hi there,

I am creating a blog app but any time I add a new post, the post goes at the end of the list on the Glide app.

Is there a way to change the order so the latest post gets to published as the first one in the app? Something like sorts the list order from A to Z to Z to A.

Thanks in advance.

Under options you could sort by sheet order from Z>A.

Or, if you have time stamps on your posts, sort by date should work too.

2 Likes

open a new sheet and in A1 cel put this function:
=sort(‘Sheet1’!1:1000,2,false)
change ‘Sheet1’ to the name of sheet you are copying, and ‘2’ to the column number to sort sheet against, false or true to reverse sort.
make sure you don’t have any functions in source sheet, otherwise start copying from second or third row.

2 Likes

hi @Eric_Penn Under option on Google sheet?

hi @Uzo I have my Title under A1, what do you recommend?

I said open a brand new google sheet

Select your inline list and then navigate to the top right.

Screen Shot 2021-06-05 at 8.58.41 PM

Sweet! Thanks

2 Likes

If it will be done in glide by filter, actual sheet will not change, it will be only for displaying purposes

2 Likes