Can a report for question with a multiple choice answer put each answer in a separate column?

  • Profile Image
    Region25
    Asked on April 04, 2013 at 04:52 PM

    We have a fairly complex event registration form.  For different time slots during the weekend evemt, each participant selects which class they plan to attend.  Currently, when I download an Excel report of all submissions, each person's selection shows up in the column for that time slot.  We are trying to calculate class size for each class during a time slot.  Is it possible to have the Excel spreadsheet create a different column for each class during each time slot with a mark in the column for the class selected?

     

    Thank you for your help,

    Connie

  • Profile Image
    EltonCris
    Answered on April 04, 2013 at 05:43 PM

    Hi Connie,

    Sorry but its' not possible currently. There's a request about this but no updates as of the moment. Fields with multiple selections like Checkbox are compressed on a single column for now.

    May I suggest to try the Matrix fields? They appears to be different than using normal checkbox when exported to excel. Selections are separated each columns.

    Example

    Mark with blue box is the result using normal checkbox field. While the red one is using matrix field with check box inptus.

    Matrix tool is under "Survey Tools", FYI.

    Note quite sure if this works for you. You can give it a try if you like. Thanks!