IF('Oleg' != [Owner], [Effort] + 10, [Effort] + 5)


IF(logical expression, expression 1, expression 2)

Logical function returns expression 1 if a logical expression is TRUE, and expression 2 if it is FALSE.

logical expression: An expression that produces a Boolean value when evaluated, i.e. one of TRUE or FALSE. The combination of data fields, constants, text, numeric and date expressions with logical operators >,<,>=, <=, != and etc. can be used to create logical expressions

expression 1: Any numerical, date or text expression can be used

expression 2: Any numerical, date or text expression can be used

Use cases

Spent time on tasks

Compare average spent hours for completed tasks over creation vs others.

Source: Tasks

Time tracking stats for tasks of the building super hero suit

Completed OnTaskHours SpentFeature
03 Jan 2018 10:13 AMCreate a steel helmet to protect head19Protective Suit
20 Jan 2018 04:08 PMCreate a chest protection from steel45Protective Suit
05 Feb 2018 11:34 AMAsk agency to create fancy identity for new super hero30Design
09 Feb 2018 02:11 PMInstall super hero logo on body and helmet2Protective Suit
09 Feb 2018 02:11 PMPut on gloves with nice color2Protective Suit
12 Feb 2018 09:01 PMAsk Hulk to push in head5Combat Testing
01 Mar 2018 06:45 PMAsk Hulk to push in chest5Combat Testing

Chart BAR

X: IF(CONTAINS([Task], 'Create'), 'Creation', 'Others')

Y: AVG([Hours Spent])


IF(CONTAINS(Task, 'Create'), 'Creation', 'Others')AVG(Hours Spent)