How to use AND Operator with IF condition in Formula Mode

[zaygum]

Hi,

I am trying to use an AND operator with IF ELSE in the Formula mode in Workato.

Trying to do something like:

IF condition1=TRUE   AND   Condition2=True
Value

Can someone please assist on this.

Thanks

[gary1 · Accepted solution]

You can use a "ternary operator", which is basically an "if" statement. It has this syntax:

logical_condition ? result_when_true : result_when_false

Example:

1 == 1 ? "true!" : "false!" ## >> "true!"

The AND operator is "&&" and the OR operator is "||"

Example:

1 == 1 && 0 == 1 ? "true!" : "false!" ## >> "false!"