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().
...
| Info |
|---|
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. |
| Expand | title |
Chained Function Calls
| Include Page | ||||
|---|---|---|---|---|
|
...
Aggregate Functions
| Include Page | ||||
|---|---|---|---|---|
|
...
User Functions
| Include Page | ||||
|---|---|---|---|---|
|