How to get checkbox responses to show in notifications?

BethanyH

I have a sheet that has several columns which are formatted as checkboxes and a form for users to submit info. The users check boxes on the form to select fields. I have set it up to send a response back to the submitter with their responses. The notice that goes back to the submitter shows the field names but does not indicate whether the box is checked or unchecked. To the recipient it looks like they submitted their response with no boxes checked. This is also true when the submitter checks the box to have a copy of their responses emailed to them. How can I show what has been checked?

John Jonassen

Yes, exactly.

=if(Checkbox1=1,"YES","NO")

John Jonassen

I wonder if you should create translator/helper columns in the underlying sheet that changes the check boxes that are submitted to a "YES" or "NO". Then on the follow up email to the submitter, reference the "YES"/"NO" columns rather than the check boxes....see if that suits your need.

BethanyH

If I understand you correctly, you mean create a set of essentially duplicate columns and use formulas to fill the copies, like if Column A is checked, column Aa = Yes. Then use the checkboxes on the form to collect my responses, but use the yes/no columns to send the response back to the submitter?

John Jonassen

Yes, exactly.

=if(Checkbox1=1,"YES","NO")

BethanyH

That's helpful. Thank you.