Sorting of form responses

%3CLINGO-SUB%20id%3D%22lingo-sub-1768664%22%20slang%3D%22en-US%22%3ESorting%20of%20form%20responses%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1768664%22%20slang%3D%22en-US%22%3E%3CP%3ECreated%20a%20form%20using%20Forms%20for%20excel%20with%20the%20results%20being%20saved%20in%20OneDrive.%26nbsp%3B%20The%20first%20few%20responses%20are%20in%20a%20logical%20order%20but%20then%20some%20start%20to%20get%20inserted%20in%20random%20order.%26nbsp%3B%20When%20I%20try%20sorting%20on%20a%20column%20header%20ID%20in%20the%20case%20below%20it%20does%20not%20work%20see%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ShawGoodwin_0-1602414403089.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F225795iEB74EB8416739A62%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22ShawGoodwin_0-1602414403089.png%22%20alt%3D%22ShawGoodwin_0-1602414403089.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EIf%20I%20try%20sorting%20on%20a%20different%20column%20-%20start%20time%20it%20does%20not%20sort%20either.%26nbsp%3B%20Anyone%20know%20a%20reason%20or%20better%20still%20a%20solution.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EShaw%20Goodwin%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1768664%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EForms%20Responses%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Esort%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Created a form using Forms for excel with the results being saved in OneDrive.  The first few responses are in a logical order but then some start to get inserted in random order.  When I try sorting on a column header ID in the case below it does not work see:

 

ShawGoodwin_0-1602414403089.png

If I try sorting on a different column - start time it does not sort either.  Anyone know a reason or better still a solution.

 

Shaw Goodwin

1 Reply

@ShawGoodwin 

@Abe_G Hi Abe, would you please take a look at this? Thanks.