Apply filters with custom conditions

Apply filters with custom conditions

To apply custom filters:

    1. Click on Custom Filter from the drop down menu.

    2. Custom Filter lets you choose your condition according to which the data must be filtered. 




Note:

Depending upon the data type chosen, the options that are used to set the conditions or criterion for filtering vary.

When the data entry is numerical, the options provided are as follows:

  • Is greater than - Displays all numbers greater than the chosen value.

  • Is greater than or equal to - displays numbers greater than or equal to the chosen value.

  • Is less than - displays numbers less than the chosen value.

  • Is less than or equal to - displays numbers less than or equal to the chosen value.

 

If the fields or data to be filtered consist of text fields, you can use the following criterion for filtering.

  • Equals

  • Does not equal

  • Begins with

  • Does not begin with

  • Ends with

  • Does not end with

  • Contains

  • Does not contain

  • Matches

  • Does not match

If you choose "contains" from the custom menu, it displays all the fields that hold the particular phrase entered as criterion.

You can also use custom filtering with dates as sorting criterion. The options that are available to filters in the form of dates include:

  • After

  • On or after

  • Before

  • On or before

 

The given conditions can be used to filter and display only those dates that follow the set criterion.


    • Related Articles

    • Advanced filters

      Apart from the various views available, you can filter records based on their field values.    For example, you want to filter out the records whose Deal closing date is due in 2 days, and is tagged as a Premium Contact, you can apply those filters ...

    • Apply a named filter

      To use or apply a named filter, Click on the dropdown arrow on the   icon in the toolbar and choose Named Filters. From the list of named filters, choose the filter you wish to apply. The filter will be applied on the specified range saved along with ...

    • Task Filters

      You can view just the tasks you need by making use of Filters. To do this: Click the Funnel icon in the top-right corner of your My Tasks or Private Tasks page. Check the filters you need to apply based on Board Name, Priority, Due Date, and Status. ...

    • Advanced Filters

      The advanced filter is a powerful search tool that enables you to extract valuable recruiting information in no time—information, which could otherwise take much longer to find out. With a regular filter, your search is based on field values, for ...

    • Apply Filter

      To apply filter: 1. Select the column or range of cells to be filtered. 2. Click Data> Filter or use the Filter icon  from Toolbar or right click on the selected range and select Filter from the context menu. 3. Choose the required filtering ...