Tuesday, November 11, 2014

yogi_In Sheets Named After WeekDays Pull Names Of People By Ticket Number From Data In 'Form Responses' Sheet

                 Google Spreadsheet   Post  #1830
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov-11-2014
post by  Scott Benhart:
Theater Box Office spreadsheet
Okay, folks, here's a multi-step conundrum for you:

I've part of our high school theater's ticket sales and we created a Google Form so patrons can make reservations. From the form, the Form Responses fall into a sheet file that also has four other sheet tabs along the bottom. These tabs contain a seating chart for each of the four performance nights (Thursday - Sunday). As responses come in, we assign seats using the seating chart. On the 'Form Responses' tab, we give them a seat assignment such as "Fri H2" (Friday night, seat H2). 

What I would like to do is set up the sheet so that it will automatically display the patron's name (another column in the 'Form Responses' tab) in the performance night's tab, underneath the cell with the seat number for that specific performance - indicated by another column on the 'Form Responses' tab. Is there a formula that will make this possible, or do I need to change something to make this possible?

See a sample sheet here

Thanks for any help you can give, please ask questions if I'm not explaining something correctly!