Sorting form responses

%3CLINGO-SUB%20id%3D%22lingo-sub-19855%22%20slang%3D%22en-US%22%3ESorting%20form%20responses%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-19855%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20collected%20form%20responses%20for%20our%20school%20board%20where%20students%20chose%20their%20school%20first.%20%26nbsp%3BWhen%20I%20click%20responses%2C%20i%20get%20all%20of%20the%20responses%20collectively.%20%26nbsp%3BI%20can%20export%20to%20Excel%20and%20sort%20by%20school%20but%20then%20I%20have%20to%20use%20a%20pivot%20table%20to%20tally%20results%20per%20school%20and%20then%20create%20the%20graph.%20%26nbsp%3BIs%20there%20any%20way%20to%20be%20in%20forms%20instead%20of%20excel%20to%20sort%20answers%20based%20on%20a%20previous%20selection%3F%20%26nbsp%3BRight%20now%20I%20can%20only%20see%20the%20entire%20set%20of%20responses%20tallied%20together%20and%20unsorted%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-19855%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EEducation%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESurvey%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-215602%22%20slang%3D%22en-US%22%3ERe%3A%20Sorting%20form%20responses%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-215602%22%20slang%3D%22en-US%22%3E%3CP%3EAny%20progress%20on%20this%20one%3F%3C%2FP%3E%3CP%3ECarrie%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-20097%22%20slang%3D%22en-US%22%3ERe%3A%20Sorting%20form%20responses%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-20097%22%20slang%3D%22en-US%22%3EHi%20Shelly%20-%20Thanks%20for%20sharing%20your%20detailed%20user%20scenario%20with%20us.%20I%20have%20added%20this%20feature%20to%20our%20backlog.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1326253%22%20slang%3D%22en-US%22%3ERe%3A%20Sorting%20form%20responses%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1326253%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F5040%22%20target%3D%22_blank%22%3E%40Nakul%20Madaan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20progress%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E4%20years%20later%20and%20this%20still%20doesn't%20appear%20to%20be%20resolved.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1417361%22%20slang%3D%22en-US%22%3ERe%3A%20Sorting%20form%20responses%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1417361%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F5040%22%20target%3D%22_blank%22%3E%40Nakul%20Madaan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20would%20be%20incredibly%20helpful%20as%20a%20feature%20for%20us%20in%20our%20work%20to%20track%20training%20activities%20in%20our%20organization.%20We%20would%20need%20to%20sort%20in%20several%20steps%3B%20Which%20hospital%2C%20Which%20department%2C%20and%20so%20on!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20are%20really%20hoping%20you%20can%20resolve%20this!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I have collected form responses for our school board where students chose their school first.  When I click responses, i get all of the responses collectively.  I can export to Excel and sort by school but then I have to use a pivot table to tally results per school and then create the graph.  Is there any way to be in forms instead of excel to sort answers based on a previous selection?  Right now I can only see the entire set of responses tallied together and unsorted

4 Replies
Highlighted
Hi Shelly - Thanks for sharing your detailed user scenario with us. I have added this feature to our backlog.
Highlighted

Any progress on this one?

Carrie

Highlighted

@Nakul Madaan 

 

Any progress?

 

4 years later and this still doesn't appear to be resolved.

 

Highlighted

@Nakul Madaan 

This would be incredibly helpful as a feature for us in our work to track training activities in our organization. We would need to sort in several steps; Which hospital, Which department, and so on!

 

We are really hoping you can resolve this!