How to use the OR operation for Computed Attributes
Definition
The OR operation allows you to test multiple condition options
Example
OR(0, True, Null)
Result:
true
Syntax Guide
OR(logical_expression1, [logical_expression2, ...])
logical_expression1 - An expression that represents some logical value, i.e. TRUE or FALSE, or an expression that can be coerced to a logical value
logical_expression2, ... - [ OPTIONAL ] - Additional expressions representing some logical values, i.e. TRUE or FALSE, or expressions that can be coerced to logical values
Formula In Use
IF(OR(EQ($STATUS,"Draft"),EQ($STATUS,"")),"Inactive")
This formula combines the EQ Operation, OR Operation, and IF Operations to state "If the Status is Draft or is empty, then the output should be Inactive."
What's Next?
- Learn more about how to write formulas
- Check out the DLOOKUP operation
- Check out the COUNTIF operation
If you have any questions just click on the chat box in the bottom-right corner and we'll be happy to answer them...
and please let us know 👇