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 conditionCompatible data typesEffect
Is trueBooleanFilters to display items with a value of True.
Is falseBooleanFilters to display items with a value of False.
Equal toNumber, Date, Time Period, List, TextFilters to display items with a value equal to the value you enter.
Is not equal toNumber, Date, Time Period, List, TextFilters to display items with a value that is not equal to the value you enter. 
Between or equal toNumber, Date, Time PeriodFilters to display items with a value between the two values you enter.
Less thanNumber, 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 toNumber, 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 thanNumber, 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 toNumber, 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 blankDate, List, TextFilters to display items that are blank.
Is not blankDate, List, TextFilters to display items that contain a value.
ContainsTextFilters to display items that contain the text string you enter.
Starts withTextFilters to display only items that start with the text string you enter.
Ends withTextFilters to display only items that end with the text string you enter.