Is there a way to only see the YES responses of my Matrix tables in excell file?

  • Profile Image
    mchugh62
    Asked on May 09, 2014 at 11:26 AM
    Is there a way to only see the YES responses in excell for the Health chart bc my spreadsheet became toooo wide with all those answers. Is there a better way to document if there are any health issues?  I am using the church's old paper form to create this.
  • Profile Image
    NeilVicente
    Answered on May 09, 2014 at 12:40 PM

    I am afraid the answer to your question is no. Matrix fields are considered as one field, but is separated on spreadsheets because there is no way to show such a table in a single column.

    A better way might be to replace the matrix field with a check box field.

    Here's how it would look:

     

    Sadly, using this solution means you will have to delete the exiting matrix field, deleting also the data that comes with it. But, you can edit the submissions and manually enter the data to the new check box field.

    Hope you find this useful. Do inform us should you need further assistance.

    Best regards

  • Profile Image
    mchugh62
    Answered on May 09, 2014 at 01:59 PM

    ok thank you

     

    When I did that ORIGINALLY before I went to matrix it still downloaded in to excell in several columns. 

    DO I need to format anything to just print the checked ones in the CHECK BOX format?

     

  • Profile Image
    NeilVicente
    Answered on May 09, 2014 at 02:20 PM

    No, there is nothing you need to do for the selected checkbox options on a regular checkbox field to come out like that.

    Were you perhaps using a checkbox-type matrix then (still a matrix)?

  • Profile Image
    mchugh62
    Answered on May 09, 2014 at 02:29 PM

    probably! thank you.

     

    I am still having trouble with the Address output in email and submissions.