Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How can I get the Google Spreadsheet to automatically order the incoming form responses alphabetically (2nd column)?

I know how to do this manually or by going in and editing a cell, but cannot get it to do this as an onevent for incoming response.

share|improve this question

I have one suggestion: on the next empty column on your Form Response:

=Query(range; "select * where x <> '' order by x" , 1)

Where range is the range of the responses and x is the column that you want to sort. Hide the columns where the answers are automatically inserted.

share|improve this answer
=Query('Form Responses 1'!B1:C300; "select * where C <> '' order by C" , 1) WOW COOL! I needed to still figure how to but what where but i saw logic in other examples. THX :) & 1 ROW needs to be name couse its static in formula. – Kangarooo Apr 27 '14 at 15:32

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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