IFNONE

IFNONE([Owner], 'No Owner')

Syntax

IFNONE(expression, default expression)

Logical function returns the specified default value if the expression is NULL.

expression: Any numerical, date or logical expression can be used

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

Use cases

Spent time on tasks

Compare spent hours for completed tasks.

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

Y: IFNONE([Task], 'No Name')

X: [Hours Spent]

Chart

SUM(Hours Spent)IFNone(Task, 'No Name')
19Create a steel helmet to protect head
2Install super hero logo on body and helmet
2Put on gloves with nice color
5Ask Hulk to push in chest
5Ask Hulk to push in head
45Create a chest protection from steel
30Ask agency to create fancy identity for new super hero