Formula (Extended): $IFS Function
Overview¶
Evaluate the first "Logical Expression" and return the paired value if it is true. If it is false, evaluate the second "Logical Expression" and return the paired value if it is true. This is repeated for each set of logical expressions and strings.
Syntax¶
Parameters¶
| Parameter | Type | Required | Description |
|---|---|---|---|
| Logical Expression 1 | Logical Expression | Required | |
| String 1 | Arbitrary String | Required | String to return if "Logical Expression 1" is true |
| [Logical Expression 2] | Logical Expression | Optional | |
| [String 2] | Arbitrary String | Optional | String to return if "Logical Expression 2" is true |
Column Usable as Parameters¶
| Parameter | Classification | Numerical Value | Date | Description | Check |
|---|---|---|---|---|---|
| Logical Expression 1 | Yes*1 | Yes*1 | Yes*1 | Yes*1 | Yes |
| String 1 | Yes | Yes | Yes | Yes | No |
| [Logical Expression 2] | Yes*1 | Yes*1 | Yes*1 | Yes*1 | Yes |
| [String 2] | Yes | Yes | Yes | Yes | No |
*1: Can be used as a variable to configure a "Logical Expression".
Example:
NumA == 1000
DateA > DateB
ClassA == "Text"
Return Value¶
String that is the pair of the logical expression that is true. It is judged from the left. An error occurs if all logical expressions are false.
Return Value for Target Column¶
| Target | Return value |
|---|---|
| Classification (including title, status, manager, owner) | Display return value. If the return value is a half-width numerical value and a drop-down list with values, display the options that match the return value. |
| Numerical Value (including work volume, progression rate, remaining work volume) | Display return value only if the return value is a half-width numerical value. |
| Date (including start and completion) | Display return value only if the return value is a string in date format. |
| Description (including content) | Display return value. |
| Check (including lock) | Do not display. |
Usage Example ①¶
Specify parameters by screen column name (name displayed)
Formula¶
Parameters¶
Calculation Result¶
