Auto sort results of a Google Form so newest responses are on top!


If you use Google forms to collect data of a long period of time you may want the newest results to post to the top of the spreadsheet. For example, I use a form as a way to track books that kids borrow, I’d rather have the newest book to be borrowed appear at the top of the list.


Here is one way you can do this.

  1. On the bottom left of the sheet click the + to create another sheet
  2. In cell A1 paste the following formula:
    1. =sort('Form Responses 1'!A:H, 1, False)
  3. You may want to double click the title of the new sheet (Which will be “Copy of Form Responses 1” and change it to something more descriptive “Sorted” is what I chose.

 

Remember, this new sheet, “Sorted,” is mirroring the “Form Responses” sheet, so any changes you make to the content will show up on the “Sorted” sheet.

Advertisements

What do you think? Share it here!

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: