Google Spreadsheet Post #1197
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. May 18, 2013
user freyj (http://productforums.google.com/forum/#!category-topic/docs/documents/how-do-i/desktop/Iy8OkzKNBF0)
Create a class roster from Google form results
I'm trying to do several things within the shared spreadsheet below. Please help if you can!
- I need a list of the courses each email address has signed up for in each column of the below spreadsheet. Place holders in tab "studentschedule" have been made in the sheet for the layout (going into another form to run FormEmailer).
- I need to ensure only the last entry from the form is counted (some folks submitted more than one form)
- I need to also create a list of email addresses that will be in each class (tab named "class rosters").
I feel like it's a simple combination of three formulas, but my head's about to explode after trying to tweek TRIM, UNIQUE, INDEX, and TRANSPOSE for three days.
Can anyone help me?
----------------------------------------------------------------------------------------------------------------------------
here we go ...
Per your email (and I'll post in Google as well) the course names from the ClassRosters Tab should be pulled from the FromForm tab (all Unique names that were chosen). I don't have an easy way to export all possible names. My form is closed, so only classes listed on FromForm are possible class names.
ReplyDeleteHi Joel: The spreadsheet associated with my response to your first questiobn is acting up, so I have presented a solution in my following blog post
ReplyDeleteyogi_CrossTab EMail Address For Each Session In Sheet Named StudentSchedule2
http://yogi--anand-consulting.blogspot.com/2013/05/yogicrosstab-email-address-for-each.html
check it out and let me know how it goes.
Make It A Great One
Cheers!
Yogi
Cloud Computing -- Google Docs Way
yogi--anand-consulting.blogspot.com