Skip to main content

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(<function>(<data source>)[condition],[if_true],[if_false])
)

Example
  • If the number of booked meetings is 40 or more, show "Target reached." If not, show nothing. Change the number format to Text.

(
IF(Count(Booked meetings)>=40,"Target reached","")
)

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.

(
IF(Count(Sales)>0,

IF(Sum(Sales)>0,1,0),
0)
)

Breakdown:

  • >0 – condition

  • IF(Sum(Sales)>0,1,0) – if true

  • 0 – if false