Stay organized with collections Save and categorize content based on your preferences.
BooleanCriteriaAn 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.
CELL_EMPTY Enum The criteria is met when a cell is empty. CELL_NOT_EMPTY Enum The criteria is met when a cell is not empty. DATE_AFTER Enum The criteria is met when a date is after the given value. DATE_BEFORE Enum The criteria is met when a date is before the given value. DATE_EQUAL_TO Enum The criteria is met when a date is equal to the given value. DATE_NOT_EQUAL_TO Enum The criteria is met when a date is not equal to the given value. DATE_AFTER_RELATIVE Enum The criteria is met when a date is after the relative date value. DATE_BEFORE_RELATIVE Enum The criteria is met when a date is before the relative date value. DATE_EQUAL_TO_RELATIVE Enum The criteria is met when a date is equal to the relative date value. NUMBER_BETWEEN Enum The criteria is met when a number that is between the given values. NUMBER_EQUAL_TO Enum The criteria is met when a number that is equal to the given value. NUMBER_GREATER_THAN Enum The criteria is met when a number that is greater than the given value. NUMBER_GREATER_THAN_OR_EQUAL_TO Enum The criteria is met when a number that is greater than or equal to the given value. NUMBER_LESS_THAN Enum The criteria is met when a number that is less than the given value. NUMBER_LESS_THAN_OR_EQUAL_TO Enum The criteria is met when a number that is less than or equal to the given value. NUMBER_NOT_BETWEEN Enum The criteria is met when a number that is not between the given values. NUMBER_NOT_EQUAL_TO Enum The criteria is met when a number that is not equal to the given value. TEXT_CONTAINS Enum The criteria is met when the input contains the given value. TEXT_DOES_NOT_CONTAIN Enum The criteria is met when the input does not contain the given value. TEXT_EQUAL_TO Enum The criteria is met when the input is equal to the given value. TEXT_NOT_EQUAL_TO Enum The criteria is met when the input is not equal to the given value. TEXT_STARTS_WITH Enum The criteria is met when the input begins with the given value. TEXT_ENDS_WITH Enum The criteria is met when the input ends with the given value. CUSTOM_FORMULA Enum The criteria is met when the input makes the given formula evaluate to true.
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-12-02 UTC.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-12-02 UTC."],[[["`BooleanCriteria` is an enumeration used to define criteria for conditional formatting or filtering in Google Sheets."],["It provides a variety of properties representing different criteria types like `CELL_EMPTY`, `DATE_EQUAL_TO`, `NUMBER_GREATER_THAN`, `TEXT_CONTAINS`, and more."],["To use a specific criteria, you call it using the syntax `SpreadsheetApp.BooleanCriteria.\u003cproperty\u003e`, for example, `SpreadsheetApp.BooleanCriteria.CELL_EMPTY`."],["Each property represents a specific condition, such as whether a cell is empty, a date is within a certain range, or text contains a specific string."],["`BooleanCriteria` helps automate tasks and enhance data analysis by enabling you to dynamically format or filter spreadsheet data based on specified conditions."]]],[]]
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4