I linked a form to google spreadsheets, so now all the responses on that form are linked, and they automatically are added as plain data in the spreadsheet. One of the columns is date-data, on column B, but the responses are added to the spreadsheets as data in ascending order of submission, so I wanted to know how to create a sort function that would automatically sort new incoming data in descending order according to Column B.

enter image description here


Try Insert > New sheet and this formula in cell A1 of the new sheet:

=query('Form Responses 1'!A1:A, "order by B desc", 1)

Alternatively, if you want to sort the Form Responses 1 sheet in place, it is better to use filter views to sort the sheet instead of using Data > Sort. A filter view definition can be saved and easily re-activated.

For additional ease of use, you can insert links in the frozen section of the sheet to easily switch between filter views, instead of having to go to Data > Filter views to switch. See the Filter views example spreadsheet for an illustration.

Not the answer you're looking for? Browse other questions tagged or ask your own question.