I have a Form that will be sent out to 100's of people across 10 properties. The first question is multiple choice where they select the property where they live. I would like to have all responses saved to a corresponding sheet in the same Excel workbook.
For example: A person selects "Property #3". Instead of one huge list of responses containing all properties to sort through, their submission will be sorted in a corresponding Sheet labeled Property #3
Is this possible?


Report
All responses (
Answers (