You can use a variety of conditions when you create a filter. The conditions available depend on the data type that you filter.
This table displays all filter conditions and the data types with which you can use them.
Filter condition | Compatible data types | Effect |
Is true | Boolean | Filters to display items with a value of True. |
Is false | Boolean | Filters to display items with a value of False. |
Equal to | Number, Date, Time Period, List, Text | Filters to display items with a value equal to the value you enter. |
Is not equal to | Number, Date, Time Period, List, Text | Filters to display items with a value that is not equal to the value you enter. |
Between or equal to | Number, Date, Time Period | Filters to display items with a value between the two values you enter. |
Less than | Number, Date, Time Period | Filters to display items with a value less than the value you enter. For Date- or Time Period-formatted data, less than refers to past dates and time periods. |
Less than or equal to | Number, Date, Time Period | Filters to display items with a value less than or equal to the value you enter. For Date- or Time Period-formatted data, less than refers to past dates and time periods. |
Greater than | Number, Date, Time Period | Filters to display items with a value greater than the value you enter. For Date- or Time Period-formatted data, greater than refers to future dates and time periods. |
Greater than or equal to | Number, Date, Time Period | Filters to display items with a value greater than or equal to the value you enter. For Date- or Time Period-formatted data, greater than refers to future dates and time periods. |
Is blank | Date, List, Text | Filters to display items that are blank. |
Is not blank | Date, List, Text | Filters to display items that contain a value. |
Contains | Text | Filters to display items that contain the text string you enter. |
Starts with | Text | Filters to display only items that start with the text string you enter. |
Ends with | Text | Filters to display only items that end with the text string you enter. |