Skip to content

Formula (Extended): $OR Function

Overview

Return true if any of the arguments are true.

Syntax

$OR(Logical Expression 1, [Logical Expression 2], ...)

Parameters

Parameter Type Required Description
Logical Expression 1 Logical Expression Required
[Logical Expression 2], ... Logical Expression Optional

Column Usable as Parameters

Parameter Classification Numerical Value Date Description Check
Logical Expression 1 Yes*1 Yes*1 Yes*1 Yes*1 Yes

*1: Can be used as a variable to configure the "Logical Expression".
Example:
NumA == 1000
DateA > DateB
ClassA == "Text"

Return Value

True if any of the arguments are true. If all are false, it's false.

Return Value for Target Column

Target Return Value
Classification (including title, status, manager, owner) Display the string "True" or "False"
Numerical Value (including work volume, progression rate, remaining work volume) Do not display
Date (including start and completion) Do not display
Description (including content) Display the string "True" or "False"
Check (including lock) Check ON if true, check OFF if false

Usage Example ①

Specify parameters by screen column name (name displayed)

Formula

Formula using the $OR function in usage example 1

Parameters

Parameters specified in usage example 1 of the $OR function

Calculation Result

Calculation result of usage example 1 of the $OR function

Usage Example ②

Specify multiple parameters

Formula

Formula using the $OR function in usage example 2

Parameters

Parameters specified in usage example 2 of the $OR function

Calculation Result

Calculation result of usage example 2 of the $OR function