Sorting determines the order case elements display in a spreadsheet view, allowing you to review information in various ways to determine what items need to be addressed first or categorized based on the status of items. Sorting is distinct to each user ID and does not affect the view that others see for this spreadsheet.
You can also sort multiple fields to change your spreadsheet view. For example, you can sort the Questions spreadsheet first by persons to whom questions are assigned, and then by the date an answer is due. You must use the Advanced Sort dialog box to create a multi-level sort. For more information, see Sorting multiple fields.
You can sort spreadsheet data by:
• | Change a field's ascending or descending order |
• | Change your spreadsheet view by inserting or hiding fields |
• | Sorting multiple fields at a time (up to three fields) |
Benefits of sorting spreadsheet fields include:
• | Creating/saving a spreadsheet view for printing reports |
• | Viewing disputed vs. undisputed facts by date and time to analyze case strategy |
• | Sorting the Questions spreadsheet before a trial date to evaluate outstanding issues |
• | Sorting objects by type and then alphabetically to locate people, organizations, and documents easier |
• | Plus many more |
Sorting is independent of any filter or tag function. If you filter the facts displayed in the Facts spreadsheet from 2,000 to 100, the 100 facts that remain are still sorted as specified by the view's sort order. |
While you can sort of most all fields in a spreadsheet, some fields in CaseMap (such as description fields) cannot be sorted. If you try to sort a field that cannot be sorted, you receive a message prompt indicating what fields on the spreadsheet are available for sorting. Reference the following table to note what spreadsheet fields are sortable and which are not.
|
Sort spreadsheets to create custom views that are distinct to your user ID. Once you sort a spreadsheet it is automatically saved in this view. Each time you open a case, the spreadsheet data display in this new view until you change the sort order again. Not only can you save a sort order, you can also rearrange spreadsheet fields to display in the order you prefer. For more information, see Creating spreadsheet views. |
Once you sort a spreadsheet it is automatically saved in this view. Each time you open a case, the spreadsheet data display in this new view until you change the sort order again. |