Formula Script with Condition

Condition can be included in the formula script

The syntax is as follows:
outcome1 if condition else outcome2
where outcome1 and outcome2 should follow the datatype of that field

image

Some useful arithmetic operators include:
arithmetic operator

Some useful comparison operators include:
comparison operator

Some useful logical operators include:
and
or

1 Like