How to build advanced filters on Pipedrive

intermediate 8 min read Updated 2026-03-18

Quick Answer

Advanced filters in Pipedrive allow you to create complex search criteria using multiple conditions and logical operators. Navigate to your deals or contacts view, click the filter icon, and combine multiple criteria using AND/OR logic to segment your data precisely.

Try Pipedrive Full Pipedrive Review

Prerequisites

Active Pipedrive account
Basic understanding of Pipedrive navigation
Knowledge of your pipeline structure
Familiarity with deal/contact fields

Step-by-Step Instructions

Access the Filter Panel

Navigate to your Deals, Contacts, or Organizations view. Click the Filter icon (funnel symbol) in the top toolbar. This opens the filter panel where you can create your advanced criteria.

The filter icon is located next to the search bar and view options

Add Multiple Filter Conditions

Click Add condition to create your first filter rule. Select a field from the dropdown (e.g., Deal value, Stage, Owner). Choose an operator like is, is not, greater than, or contains. Enter your criteria value. Repeat this process to add multiple conditions by clicking Add condition again.

Start with your most specific criteria first to narrow down results effectively

Configure Logic Operators

Between each condition, you'll see AND or OR options. Select AND when all conditions must be true (e.g., deals > $1000 AND in Negotiation stage). Choose OR when any condition can be true (e.g., Stage is Proposal OR Stage is Negotiation). Mix these operators to create complex logic chains.

Use parentheses grouping for complex logic like (A AND B) OR (C AND D)

Use Date Range Filters

For time-based filtering, select date fields like Created date or Expected close date. Choose operators such as is in the last, is in the next, or is between. Specify time periods using options like 7 days, 1 month, or custom date ranges. This helps track pipeline velocity and upcoming deadlines.

Use relative dates like 'last 30 days' for filters that update automatically

Apply Custom Field Filters

Access your custom fields in the condition dropdown under their respective categories. For single option fields, select from predefined values. For multiple option fields, use contains any or contains all operators. For numeric fields, use comparison operators like greater than or less than.

Custom fields appear in the dropdown based on the object type you're filtering

Group and Organize Conditions

Click the Group conditions option to create nested logic. Drag conditions into groups to organize complex filters. Use the parentheses to control the order of operations. For example: (Stage is Proposal AND Value > $5000) OR (Stage is Negotiation AND Owner is Me).

Group related conditions together to make your filter logic easier to understand and maintain

Save and Name Your Filter

After configuring your conditions, click Apply filter to see results. To save for future use, click Save as new filter. Enter a descriptive name like High Value Deals - Q1 2026. Choose visibility options: Private (only you can see) or Shared (team members can access).

Use descriptive names that indicate the filter purpose and time frame

Test and Refine Your Filter

Review the filtered results to ensure they match your expectations. Check the result count displayed at the top. If results are too broad, add more restrictive conditions. If too narrow, remove conditions or change AND operators to OR. Use the Clear all filters option to start over if needed.

Export a small sample of filtered results to verify data accuracy before using the filter for reporting

Common Issues & Troubleshooting

Filter returns no results despite having matching data

Check for conflicting conditions using AND operators. Verify date ranges aren't too restrictive. Ensure custom field values match exactly, including capitalization and spacing.

Custom fields not appearing in filter dropdown

Verify you have the correct permissions to view the custom field. Check that the custom field is active and assigned to the correct object type (deals, contacts, or organizations).

Saved filter not showing updated results

Click the Refresh button or reload the page. Check if the filter uses absolute dates that may need updating. Verify your permissions haven't changed for the filtered data.

Complex filter logic not working as expected

Simplify the filter by testing individual conditions first. Use the Group conditions feature to organize logic clearly. Check operator precedence - AND conditions are evaluated before OR conditions.

Prices mentioned in this guide are pulled from current plan data and may change. Always verify on the official Pipedrive website before purchasing.

Visit Pipedrive View Pipedrive Pricing