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

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.

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

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?

 

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)?

probably! thank you.

 

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