CODEWITHSUNDEEP
google-sheets
Jen Giffen
Jen Giffen

Reputation: 1

Reversing the order of items on a Google Sheet populated by a Google Form

I have a Google Form that populates to a Google Sheet. I want the new entries to appear at the top instead of the bottom...is there a script to do this? I don't even know where to begin.

Upvotes: 0

Views: 349

Answers (1)

pnuts
pnuts

Reputation: 59450

You might try (I haven't) working from a copy of your form results (say they are in Form responses 1 and span the first 26 columns):

=query('Form responses 1'!A:Z,"order by A desc")

in A1 of a new sheet.

Upvotes: 2

Related Questions