Set up and filter columns

In FileRoom, you can use columns to view your binders and find particular binders. Using
COLUMN SETUP
, you can choose which columns are visible. You can also change the width of your columns, sort the data in the columns, and filter the columns. These settings are saved for each individual user and won’t impact other users at the firm.

Choose displayed columns

  1. On the Sureprep ribbon, select
    Column Setup
    .
  2. A list of all columns will show.
    SP Client ID
    and
    Binder ID
    will be automatically selected and grayed out so you can't select them. These columns are included by default and can't be removed.
  3. Mark the checkbox next to the columns you want to show in FileRoom. To show all columns, mark the
    Select All
    checkbox at the top of the list.
  4. Select
    Save
    to display the selected columns in FileRoom or select
    Close
    to go back to the screen without saving.

Resize columns

To resize a column's width, point to the middle of 2 columns, when the
Resize
icon  appears, select and drag the edge of that column.

Sort columns

Follow these steps to change the sort order:
  1. Select a column header to sort that column alphanumerically. A sort direction arrow will appear next to the header of the column being sorted.
  2. Select the header a 2nd time to reverse the sort order. The direction of the arrow will change from up to down or vice versa.

Filter columns

You can filter the data shown in FileRoom using the filter function.
  1. Select the
    Filter
    icon  in the column you'd like to filter.
    Column filters will only be available for commonly used columns:
    • SP Client ID
    • Client Name
    • Binder ID
    • Tax Client ID
    • Status
    • Service
    • Leadsheets
    • Binder Type
    • Owner
    • Office Location
  2. For example, if you filter the Owner column, a list of owners will show by family name, followed by first name. You can go to the
    Show items that match exactly
    field and enter the exact text you want to filter, then select
    Filter
    .
    Once the column filter is applied, only the binders that match that owner name will show in the Owner column.
    Certain columns will have multiple filter options:
    For example, if you filter the SP Client ID column, you can select the
    Show items with value that
    dropdown and choose either
    Is equal to
    or
    Contains
    then enter the filter text.
  3. When you select
    Filter
    , only the binders that match the chosen filter will show.
  4. If you want to turn off the filter for a specific column, select the filter icon on the column header then select
    Clear Filter
    in the filter panel.
  5. If you want to remove the filters on all columns, select
    Clear Filter
    .
You can also use the search feature to find information that partially ‘contains’ the text for the following columns:
  • SP Client ID
  • Binder ID
  • Tax Client ID

Column setup list

You can select which of the following columns to view or hide. Certain columns are enabled by default and can't be disabled.
  • 7216 Consent
  • Actual Hours
  • Binder ID
  • Binder Linked with
  • Binder Type
  • Budgeted Hours
  • Client Due Date
  • Client Engagement ID
  • Client Name
  • Consolidated Group
  • Downloaded On
  • Due Date
  • E-Access
  • Estimated Complexity
  • Expedite
  • Leadsheets
  • Live Sync Status
  • Locked
  • Members
  • Modified On
  • Notes
  • Office Location
  • Owner
  • Pages
  • Processed By
  • Ratings
  • Restrict by Office
  • Service
  • SP Client ID
  • Status
  • Submitted On
  • SurePrep Support Access
  • Tax Client ID
  • Tax Software
  • Tax Year

Column filter options

Columns
Filters available:
SP Client ID
  • Equals to
  • Contains
Status
  • Equal to
  • Contains
  • Not Equal to
Client Name
  • Equals to
  • Contains
Owner
  • Equals to
  • Contains
Office Location
  • Equals to
  • Contains
Binder ID
Tax Client ID
Service
Leadsheets
Binder Type
  • Equals to
Chat now

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close