Be one of our first users and enjoy an exclusive 50% lifetime discount. Learn more

Filter

Filters let you show only the rows that match specific conditions. You can apply filters to individual columns or create filter groups with multiple conditions using And/Or logic.

  1. Click "Filter" in the toolbar to open the filter panel.
  2. Click "+ Add filter" to add a condition. Select a column, choose a condition type, and enter a value.
  3. Click "+ Add filter group" to add a nested group of conditions with its own And/Or logic.
  4. To add more conditions within a group, click "+ Add filter" inside the group.
  5. Click "Save" to apply the filters, or "Clear all filter" to remove them.
Equal to

Returns rows where the column value exactly matches the entered value. For example, if you enter "Apple", only rows where the column contains exactly "Apple" will be shown.

Not equal to

Returns rows where the column value does not match the entered value. For example, if you enter "Apple", all rows except those containing "Apple" will be shown.

Contains

Returns rows where the column value includes the entered text. For example, if you enter "App", rows with "Apple", "Application", or "Happy" will all be shown.

Does not contain

Returns rows where the column value does not include the entered text. For example, if you enter "App", rows containing "Apple" or "Application" will be hidden, while others remain visible.

Is empty

Returns rows where the column has no value (blank cells). For example, if a column has missing entries, only those empty rows will be shown.

Is not empty

Returns rows where the column has any value (non-blank cells). If a column has both filled and empty rows, this filter will show only the rows that contain data.

Greater than

Filters rows where the column value is strictly greater than the entered value. For example, if you enter "10", only rows with values greater than 10 (e.g. 11, 20, 100) will be shown.

Greater or equal to

Filters rows where the column value is greater than or equal to the entered value. For example, if you enter "10", rows with values of 10 or more (e.g. 10, 11, 20, 100) will be shown.

Less than

Filters rows where the column value is strictly less than the entered value. For example, if you enter "10", only rows with values less than 10 (e.g. 1, 5, 9) will be shown.

Less or equal to

Filters rows where the column value is less than or equal to the entered value. For example, if you enter "10", rows with values of 10 or less (e.g. 1, 5, 10) will be shown.

Has an error

Returns rows where the enrichment process encountered an error — such as a failed API call, a ChatGPT response error, or other data processing issues. For example, rows where an API returned an error code or ChatGPT failed to generate content.

Does not contain an error

Returns rows where the enrichment completed successfully without any issues. For example, rows where valid JSON was provided and ChatGPT successfully filled the row.

Returned data successfully

Returns rows where the enrichment process returned valid data — such as a person's company, position, or email being successfully retrieved.

Did not return data successfully

Returns rows where the enrichment ran but returned no usable data. For example, rows where the API couldn't find the requested person, or ChatGPT didn't generate relevant content.

Has not run

Returns rows where the enrichment process has not been triggered yet. For example, rows where no API call or ChatGPT generation was initiated.

Table of content:

line background

Learn from the best in our private Slack community.

Join a network of industry leaders and gain exclusive insights, tips, and strategies.

Join community