Condition

(or when when the Expression or value will be applied)

Description

The condition may also be an Expression however the result will be either true or false. If the Condition is true then the calculated value will be applied if false then it will be left blank or empty. There are some special rules that can be applied to the condition over and above the functions that are included in the expression.

Examples

++:+::SBF
Check the assigned folder to see if any of its subfolder(s) is(are) checked. The current folder item will be checked, set true, if the condition is true otherwise no change.

++:+-::ITT~~='hello'
If the Item Text contains the string 'hello' the assigned folder will be checked, set true, and if not, the folder will be unchecked.

++:+:[Done]:[Done] && ITT ~~= 'hello'
Set folder value to <Done> value if the item text contains string 'hello' ( It can be used as conditional Merge Column Value)

ITT ~= 'hello' && <Done>
Item text has the string 'hello and the folder Done is set

ITP~=1 && <Done>'20070101'
Item type is text (1) and folder Done is '20070101'