This article is for Cloud. Visit Data Center
Expr Language - Functions
- Jaramy Conners
Owned by Jaramy Conners
A function calculates a value based on its arguments and, sometimes, some external aspect. A function call is written as the function name, followed by parentheses, which may or may not contain arguments.
Examples:
SUM(-original_estimate, remaining_estimate, time_spent)CASE(priority, 'High*', 5, 1)TODAY()
Function names are case-insensitive. You can write TODAY() or Today().
There are 100+ standard functions available with Structure – see Expr Function Reference for a complete list.
Function arguments may be separated by comma (,) or semicolon (;). But in every function call within a formula, you need to use either all commas or all semicolons.