Formulas allow you to do calculations, parse strings, insert images, and much more. Formulas are the composition of functions, parameters, data fields, and references to cells. All formulas are preceded by an = character.
Functions
A suite of built-in functions are available to use in most formulas. Functions are listed in the formula editor, along with a description for how they work, and what type of arguments to use in them.
Functions are formatted in the following manner:
=FunctionName(argument1,argument2)
The FunctionName is the name of the function to use. Insert each argument in the correct location in the parentheses, separated by a comma.
Arguments can be text, cell values, parameters, or even other functions. All that matters is that the argument evaluates to the correct type for the function.
Parameters
Parameters return special values depending on some condition. The built-in parameters are:
To find out if you have more parameters available in your environment, contact your administrator.
Data Fields
To use a data field in a formula, use the following format:
={DataCategory.DataField}
Cell References
To use the value from another cell in a formula, use the following format:
=[C#] where C is the letter of the cell column, and # is the number of the cell row
Caution. Rearranging cells may cause cell references to break. Be sure to verify that your formulas are correct.