Logical calculations

Returns `TRUE` if all of the provided arguments are logically true
([Effort] < 2) AND ([Effort] > 0) use this sample
Returns a value when the first condition is met.
CASE WHEN [Status] == 'In Dev' THEN 'In Progress' WHEN [Status] == 'In Testing' THEN 'In Progress' ELSE 'Done' use this sample
Returns `TRUE` if expression contains the defined text, and `FALSE` otherwise
CONTAINS([Owner], 'Oleg') use this sample
Returns `TRUE` if expressions are equal, and `FALSE` otherwise
[Price] == 200 use this sample
Returns `TRUE` if left is strictly greater than right, and `FALSE` otherwise
[Effort] > 2 use this sample
Returns `TRUE` if left than or equal to the right value, and `FALSE` otherwise
[Effort] >= 2 use this sample
Returns expression 1 if a logical expression is `TRUE`, and expression 2 if it is `FALSE`
IF('Oleg' != [Owner], [Effort] + 10, [Effort] + 5) use this sample
Replaces `NULL` with the specified default value
IFNONE([Owner], 'No Owner') use this sample
Returns `FALSE` if expression is null or undefined, and `TRUE` otherwise.
IS_NOT_NULL([Owner]) use this sample
Returns `TRUE` if expression is null or undefined, and `FALSE` otherwise
IS_NULL([Owner]) use this sample
Returns `TRUE` if left is strictly less than right, and `FALSE` otherwise
[Effort] < 2 use this sample
Returns `TRUE` if left is less than or equal to the right, and `FALSE` otherwise
[Effort] <= 2 use this sample
Returns `TRUE` if expression matches the defined pattern, and `FALSE` otherwise
LIKE([Owner], 'Ol%g') use this sample
Returns `TRUE` if the provided argument is logically false
NOT([Effort] == 0) use this sample
Returns `TRUE` if expressions are not equal, and `FALSE` otherwise
[Price] != 200 use this sample
Returns `TRUE` if any of the provided arguments are logically true
([Effort] < 2) OR ([Effort] == 5) use this sample