Registration Sign up with Confirmation emails

[priesterdl]

Hi,
I need help creating a formula that will tell me which workshop sessions a person has signed up for. My department is providing 11 different workshops with different session times. For example, session ABC is offered at 3 different times. I need to figure out a way to automatically have a specific cell tell me the sessions and times they have signed up for, instead of scrolling and looking up the data manually for each person. I need to send confirmation emails to the people registered and want all the sessions they have signed up for to be shown in one specific cell, so I can quickly copy and paste it into an email.

In my spreadsheet each session is in one column, so Blackboard Collaborate is in column B, Capture Lectures with Panopto is in column C, Panopto to Engage Students is in column D, and Intro to Google Apps is in column E. So looking down the column, you could have multiple people signed up for Blackboard Collaborate on 9/18, 9/24, 10/12 etc. Looking across the row, one person could be signed up for 5 sessions out of the 11 being offered.


So in cell M2, I need to see all the sessions that Barbara signed up for:
Panopto Lecture - 10/22, 12:00 - 1:30 pm
Panotpto Students 10/12, 12:00 - 1:00 pm
Google Apps 10/26, 11:00 -12:00
and so on.

Does this make sense?

[HangMan]

Very simply, you could change the layout you currently have to that shown on 'Form Responses 2', then filter by 'Yes' for each Student and copy the content of column A into your email. I'm not sure if that would achieve what you want in the way you want it but it will certainly do the job and be less cumbersome than using a formula.