What happened
What this says
Current to 11 Oct 26Wes asked how to filter contract reviews by client and date to replace manual spreadsheet work. Bethan provided step-by-step instructions for Advanced filters and saving templates.
Problem: Wes was manually downloading data and cross-referencing in spreadsheets each week to pull contract reviews by client and date. Handling: Bethan gave clear instructions on using Advanced filters and saving templates for repeat searches, and mentioned the dashboard builder as an option. Watch: Wes is adopting more sophisticated query patterns, signalling readiness for higher-tier features.
Details
Updated 9 Oct 26Trail
- created · Wes Jago 16 Jul 2024 14:18Hi, I'm trying to set up a way to pull contract review information by client within the brain. Currently I'm downloading data to a spreadsheet and cross-referencing manually, which is eating up time. I need to filter by client type and review dates. Can you point me to how to do this? Cheers, Wes
- public_reply · Wes Jago 16 Jul 2024 15:45Also, I'm wondering if I can save this as a regular search rather than running it each time. I check these reviews weekly.
- public_reply · Bethan Lister 16 Jul 2024 17:00Just so I've got this right, you want a saved search that shows contract reviews by client and date? Absolutely doable. Go to Search, click Advanced filters, add your conditions for client type and date range, then hit Save as template. That way you can run it any time. You can also set up a dashboard if you want to see the data in one view.
- public_reply · Bethan Lister 17 Jul 2024 12:13Can you try that and tell me what you see? I'm here if you need a walk-through on building a dashboard too. Thanks, Bethan
- status_change · 23 Jul 2024 23:59