User Manual

10.03.2024

MANUAL

Formula (Extended): $OR Function

## Overview Return true if any of the arguments are true. ## Syntax ``` $OR(Logical Expression 1, [Logical Expression 2], ...) ``` ## Parameter |Parameter|Type|Required|Description| |:---|:---|:---|:---| |Logical Expression 1|[Logical Expression](/en/manual/formula-function-logical-expression)|Required|| |[Logical Expression 2], ...|[Logical Expression](/en/manual/formula-function-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](/en/manual/formula-function-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 ![image](https://pleasanter.org/binaries/c861c701d0654ac7aab651d79619b581) ### Parameters ![image](https://pleasanter.org/binaries/aee27aac3b184528a8b2df4ffe0c4569) ### Calculation Result ![image](https://pleasanter.org/binaries/70f92470c1784a44b0751140bef6d4b8) ## Usage Example ② Specify multiple parameters ### Formula ![image](https://pleasanter.org/binaries/1a4c0183a9434da0a41328d67ab7be0b) ### Parameters ![image](https://pleasanter.org/binaries/df4a9b18df4f4f85972e941c7ac79f6e) ### Calculation Result ![image](https://pleasanter.org/binaries/e447fedbaccc461cb0c4a9cd3dfa4dc7)
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.