How to sort a table in Google Sheets

I have read a lot about sorting tables using lists but I haven’t found one that is the same as my problem. I am trying to make a timetable app. and the main feature is that it can display the class that is the closest to the current time. The user can enter their classes on different days but it would not be sorted. For example, a user can input that class A he has at 13:05 and submits it. Afterwards he could input class B that is 12:05. in the table class A comes first before class B. i have tried using bubble sort and it wouldn’t work.

image

Hi
If you use Airtable instead of Googlesheet then it is easy to sort your data according to any column you like.

isn’t there any way for me to use sheets?

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.