IF
IF('Oleg' != [Owner], [Effort] + 10, [Effort] + 5)Syntax
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 On | Task | Hours Spent | Feature |
|---|---|---|---|
| 03 Jan 2018 10:13 AM | Create a steel helmet to protect head | 19 | Protective Suit |
| 20 Jan 2018 04:08 PM | Create a chest protection from steel | 45 | Protective Suit |
| 05 Feb 2018 11:34 AM | Ask agency to create fancy identity for new super hero | 30 | Design |
| 09 Feb 2018 02:11 PM | Install super hero logo on body and helmet | 2 | Protective Suit |
| 09 Feb 2018 02:11 PM | Put on gloves with nice color | 2 | Protective Suit |
| 12 Feb 2018 09:01 PM | Ask Hulk to push in head | 5 | Combat Testing |
| 01 Mar 2018 06:45 PM | Ask Hulk to push in chest | 5 | Combat Testing |
Chart BAR
X: IF(CONTAINS([Task], 'Create'), 'Creation', 'Others')
Y: AVG([Hours Spent])
| IF(CONTAINS(Task, 'Create'), 'Creation', 'Others') | AVG(Hours Spent) |
|---|---|
| Creation | 31.33 |
| Others | 3.5 |