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. |
