Advanced Tip: Matter List Filtered by Updated Date

Last month I explained how to use the Time Matters Inactivity Watch to spot Matters that may need attention. That involves checking the Alerts, Reminders and Watches screen. You may prefer a different approach to literally keep tabs on Matters that are going stale.

Using advanced Time Matters features, you can create a Quick Tab on your Matters List to spot Matters that you may need to follow up on.

Before You Start

As this is an Advanced Tip, I won’t spell out all the steps in detail. They involve customizing fields and creating a Quick Tab. Check with your Time Matters expert, either an in-house person or your Time Matters consultant, before customizing the program.

To create a Quick Tab showing Matters that may need attention:

  1. In the Matter Form, customize a spare field as a Date field named Updated. Check the box, Set to Today’s Date when Changed.

  2. Customize another spare field as a Calculated field. Choose the Result Format as Date.

    1. In the formula's first row select your Updated date field.

    2. Second row, the plus sign.

    3. Third row, choose Number and enter 60 (or a different number of days with no updates to the Matter record)

  3. Create a Quick Tab in the Matters List.

  4. Use an Advanced Search, selecting the Calculated field

  5. Choose: Date In Range, All to Date.

The Quick Tab will now show all Matters whose Matter Forms have not been updated in the last 60 days. Adding 60 in the Calculated Field pushes the date value of more recently modified Matters beyond Today. That means they won't show in this Quick Tab.

For this Quick Tab to work, you need to periodically open and re-save your Matter records as you work on them or review them.

Do you have a favorite Time Matters tip? Please let me know. Send me an email… or call 952.922.1727. Thank you!

Wells H. Anderson, J.D., CIC, CEO - Active Practice LLC