Saturday, August 17, 2013

yogi_Automatic Sorting Of Form Responses Data By Columns D And B

                                          Google Spreadsheet   Post  #1336
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug, 17 2013
user Carrie Sanders 695 (http://productforums.google.com/forum/?zx=w2l93ktjgxm4#!category-topic/docs/spreadsheets/eU2MVSDIPRg)
Sorting Issue
I am using a sheet that was created for me by another user.  Up until the last week it has been working wonderfully.  Last week, no longer allowed me to sort any of the data.

https://docs.google.com/spreadsheet/ccc?key=0At-TqrcM25CfdE5hcG9OX2NRcThSeUpyNnFUeHJDeXc#gid=8  Here is the sheet.  Data comes from a form. 

When I enter new data via the form it shows up at the bottom of the form.(see lines 523 and down)  I want the form to be sorted alphabetically by column D (breed) then by column B (name).  When I click on column D and click on the Data tab the option to sort is greyed out for me.

Question1: How can I sort if it is greyed out?
Question 2: Is there a way to autosort the data when it comes into the sheet itself? (so I don't have to sort it later)

Thanks for your time!

----------------------------------------------------------------------------------------------------------------------------------------------