Enum BooleanCriteria

BooleanCriteria

An enumeration representing the boolean criteria that can be used in conditional format or filter.

To call an enum, you call its parent class, name, and property. For example, SpreadsheetApp.BooleanCriteria.CELL_EMPTY.

Properties

PropertyTypeDescription
CELL_EMPTYEnumThe criteria is met when a cell is empty.
CELL_NOT_EMPTYEnumThe criteria is met when a cell is not empty.
DATE_AFTEREnumThe criteria is met when a date is after the given value.
DATE_BEFOREEnumThe criteria is met when a date is before the given value.
DATE_EQUAL_TOEnumThe criteria is met when a date is equal to the given value.
DATE_NOT_EQUAL_TOEnumThe criteria is met when a date is not equal to the given value.
DATE_AFTER_RELATIVEEnumThe criteria is met when a date is after the relative date value.
DATE_BEFORE_RELATIVEEnumThe criteria is met when a date is before the relative date value.
DATE_EQUAL_TO_RELATIVEEnumThe criteria is met when a date is equal to the relative date value.
NUMBER_BETWEENEnumThe criteria is met when a number that is between the given values.
NUMBER_EQUAL_TOEnumThe criteria is met when a number that is equal to the given value.
NUMBER_GREATER_THANEnumThe criteria is met when a number that is greater than the given value.
NUMBER_GREATER_THAN_OR_EQUAL_TOEnumThe criteria is met when a number that is greater than or equal to the given value.
NUMBER_LESS_THANEnumThe criteria is met when a number that is less than the given value.
NUMBER_LESS_THAN_OR_EQUAL_TOEnumThe criteria is met when a number that is less than or equal to the given value.
NUMBER_NOT_BETWEENEnumThe criteria is met when a number that is not between the given values.
NUMBER_NOT_EQUAL_TOEnumThe criteria is met when a number that is not equal to the given value.
TEXT_CONTAINSEnumThe criteria is met when the input contains the given value.
TEXT_DOES_NOT_CONTAINEnumThe criteria is met when the input does not contain the given value.
TEXT_EQUAL_TOEnumThe criteria is met when the input is equal to the given value.
TEXT_NOT_EQUAL_TOEnumThe criteria is met when the input is not equal to the given value.
TEXT_STARTS_WITHEnumThe criteria is met when the input begins with the given value.
TEXT_ENDS_WITHEnumThe criteria is met when the input ends with the given value.
CUSTOM_FORMULAEnumThe criteria is met when the input makes the given formula evaluate to true.