How does it work?
Currently, you can only write IF statements in the Advanced formula editor.
Plecto's IF statements work similarly to those in Excel with the following syntax:
If the number of booked meetings is 40 or more, show "Target reached." If not, show nothing. Change the number format to Text.
Nested IF statements
You can include additional IF statements inside an IF statement's [if_true],[if_false] fields.
In the example below, the formula will check whether the number of sales is greater than 0 and also if the sum of sales is greater than 0. If both are true, the formula will return 1; otherwise, it will return 0.
>0 – condition
IF(Sum(Sales)>0,1,0) – if true
0 – if false