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

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

Any progress on this one?

Carrie

@Nakul Madaan 

 

Any progress?

 

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

 

@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!

From what i can find on the internet this issue still doesn't appear to have been addressed. This is something that would be really helpful as we use the same form ongoing for different sessions as we don't want the link address to change but that means all the data is lumped together unless we export to Excel and then we have to do further things to get visual representation of the data. This is making us reluctant to use Forms as a result.