...
A formula can only reference columns from it's own worksheet and one other worksheet in the workbook. Referencing columns from different worksheets is possible after a join sheet has first been created.
| Syntax for referencing a worksheet and column | ||
| Syntax | Example | |
|---|---|---|
| Worksheet | # | #apache_log |
| Column | ! | !remoteUser |
| Worksheet and column | #apache_log!remoteUser | |
Writing a function in the formula editor
...
Enter a function name into the formula editor (case insensitive) with variables separated by a semicolon within parentheses.
Example: | Result explained |
|---|---|
| GE(#apache_log!status;400) | The Greater Than or Equal To function is being used comparing the "status" column from the "apache_log" worksheet |
Writing nested functions in the formula editor
From the formula editor, you can enter functions and operators within functions.
| Example | Results explained |
|---|---|
| IF(EQUALS(#apache_log!status;400);"Bad Request";"other") | The IF function is being used with the Equals function as one of the variables. |
| Anchor | ||||
|---|---|---|---|---|
|
...