Tracking Status of Forms results in Excel spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1233640%22%20slang%3D%22en-US%22%3ETracking%20Status%20of%20Forms%20results%20in%20Excel%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1233640%22%20slang%3D%22en-US%22%3E%3CP%3EI%20created%20a%20Form%20survey%20to%20enable%20various%20teams%20to%20enter%20in%20requests%20for%20when%20they%20need%20a%20customer%20agreement%20reviewed%20by%20various%20company%20departments.%26nbsp%3B%20The%20plan%20is%20to%20use%20the%20spreadsheet%20to%20track%20the%20status%20of%20the%20request.%20I%20added%20various%20tracking%20columns%20on%20the%20end%20of%20the%20response%20capture%20spreadsheet.%26nbsp%3B%20It%20looks%20and%20works%20great%20until%20you%20sort%20or%20filter%20data.%26nbsp%3B%20It%20seems%20the%20columns%20that%20come%20from%20the%20Forms%20survey%20sort%2Ffilter%20independently%20from%20the%20columns%20added%20on%20the%20back%20to%20track%20the%20status.%26nbsp%3B%20Why%20would%20this%20function%20differently%20than%20a%20standard%20excel%20document%3F%3F%20All%20my%20data%20is%20misaligned%20at%20this%20point%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1233640%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

I created a Form survey to enable various teams to enter in requests for when they need a customer agreement reviewed by various company departments.  The plan is to use the spreadsheet to track the status of the request. I added various tracking columns on the end of the response capture spreadsheet.  It looks and works great until you sort or filter data.  It seems the columns that come from the Forms survey sort/filter independently from the columns added on the back to track the status.  Why would this function differently than a standard excel document?? All my data is misaligned at this point

0 Replies