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.
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
I have one suggestion: on the next empty column on your Form Response:
=Query(range; "select * where x <> '' order by x" , 1)
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.