if you either right click on the top of the column, or left click on the column's letter (A,B,C etc), you'll see options that allow you to sort by whichever choice you wish.
Hope this helps
Thanks for the response, but perhaps I didn't phrase my question correctly.
Let's say I have a muilti-select field with the following responses: Answer One, Answer Two, and Answer Three.
If someone selects all three responses, the results are concatenated together as "Answer One; Answer Two; Answer Three". When exported, these results end up in a single column. So, how do I figure out all of those people who checked Answer Two? I can't sort on that.
In other form engines (FormSite), each multi-select option is exported to a unique column (i.e., one column for Answer One, one column for Answer Two, etc.). If someone selected that response, that is indicated by an X. So, it is easy to determine who selected each respective response.
Is there anyway to accomplish this in Adobe Forms?
Did you try the right click and leftclick on the column letter? I'm pretty sure that addresses the issue.
Here are a couple of screen shots using a multiselect field with choices "AnswerOne AnswerTwo AnswerThree"
Here is what happens when you right click on the column heading:
Here is what happens when you left click on the column's letter (in this case B):
You'll see that in both cases, you can sort first or last by any of the options in the multiselect field. If you sort first by AnswerOne, all the responses that chose "AnswerOne" will show up first. If you sort last by "AnswerOne" all of them will show up last.
Does this solve the issue you're describing?
Another option would to use the filtering functionality. If you open up FormsCentral, go to the Help Menu, and click on FormsCentral Help, then click on "View Responses" and click on "Sort and Filter data", it will walk you through filtering data. Here is the link
You can set up filters to show only the response that answer "AnswerOne" or any number of combinations ("AnswerOne" AND "AnswerThree", "AnswerTwo" OR "AnswerThree").
Hope one of these two methods helps
Thanks for your helpful and thourough response. Being able to sort by response is hepful when viewing online. However, that doesn't quite solve my problem. My client needs an export of the data as an Excel file every couple of days. They then take the data and import it into their database, etc. With all of the multi-select responses concatenated and exported to one column, it is hard to work with the data. If each response was exported to a unique column (indicated by an X or something), the data is very easy to work with.
I'm sure there are use cases where exporting the responses all to one column makes sense. For my particular use case, I just don't see a solution.
thank you for the feedback and for explaining your workflow. The team has been made aware of the issue and appreciates your feedback since it helps us make the product better and prioritize future enhancements.
Just to throw a potential work around you way; you should be able to do what you need in Excel. It's not ideal but it might solve your problem in the interim.
You could create some extra columns after the multiselect field's column and write something to figure out the answers. For example, if the multiselect field is in Column B, you might insert 3 columns (C,D, and E), and have these expressions in each:
=IF(ISNUMBER(SEARCH("AnswerOne", B2)),"X", "" )
=IF(ISNUMBER(SEARCH("AnswerTwo", B2)),"X", "" )
=IF(ISNUMBER(SEARCH("AnswerThree", B2)),"X", "" )
I'm not an Excel expert by any measure, but these expressions should show an X in Columns C,D, and E if the value in Column B has "AnswerOne", "AnswerTwo" and "AnswerThree" respectively... The disadvantage of course if that you'd have to create these columns after every export, and being that they are calculated columns I'm not sure how they would be exported to a database.
Thanks once again for your feedback,
Clearly, you are a genius. Fantastic solution. Works perfectly.