“Formula” fields bring the power of Excel formulas directly into Woodpecker. By utilizing “Formula” fields, you can perform mathematical operations on other Woodpecker fields and automatically calculate the dynamic data that your document needs.
When creating a formula field, the formula may contain static values, references to other fields, or both. Almost anything you can do in Excel, you can with with a Woodpecker field.
Referencing fields
To use a field in a calculation simply enter the name of the field surrounded by braces:
{Price} * {Number of items} * 10
Formatting
You can specify the format for the result of a formula field if the result is a date or a number. The “format” dropdown within the formula field will allow you to select from several date formatting options as well as integer and decimal formatting options.
Errors
- #ERROR! General error.
- #DIV/0! Divide by zero error.
- #NAME? Unrecognized function name or variable name.
- #N/A Indicates that a value is not available to a formula.
- #NUM! Occurs when formula encounters an invalid number.
- #VALUE! Occurs when one of formula arguments is of the wrong type.
NOTE: When referencing fields within functions, you may see #ERROR!, #NAME?, or #VALUE! errors. Try surrounding the field references with quotes like this if that happens:
CONCATENATE("{Governing State}","{Will Owner Name}")
Operators and functions
For a detailed reference of all supported operators and functions, please see the formula field reference.