Report to itemize responses

Rachel McLaughlin

Hello! I am trying to develop a report that will list out which Residents have selected which Attendings with whom they have worked - here is the sheet that comes from the form I've created - they just click the box for which ones they've worked with. I then want to be able to have a report that lists each Attending with the Residents underneath (ie Dr. Miller would have John Smith and Mike Jones listed beneath him, not just "2"). Is that possible to do?

L_123

You want it in a single cell below the results?

=join(collect([Resident Name]1:[Resident Name]3,Miller1:Miller3,@cell = 1),", ")

If you want the names in individual cells you can use index(collect()) in the same format as above.

Rachel McLaughlin

Thank you!!

L_123

You want it in a single cell below the results?

=join(collect([Resident Name]1:[Resident Name]3,Miller1:Miller3,@cell = 1),", ")

If you want the names in individual cells you can use index(collect()) in the same format as above.

Rachel McLaughlin

Thank you!!