Woodpecker formula fields

“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.

 
Woodpecker formulas
 

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.

 
Formula format
 

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

operators

Operator

&

Description

Concatenate text values into a single text value.

To concatenate static text, surround it with double quotation marks. To concatenate double quotation marks, you need to use a backslash (\) as an escape character.

Equivalent to CONCATENATE().

Examples

{Name} & " - " & {Age}
=> John - 32
+
-
*
/
^
>
<
>=
<=
=
!=

Add together two numeric values

Subtract two numeric values

Multiply two numeric values

Divide two numeric values

Raise a number to a power

Greater than

Less than

Greater than or equal to

Less than or equal to

Equal to

Is not equal to

{Quantity} + 3
{Fee} - 35
{Fee} * {Quantity} 
{Fee} / {Group size}
2^3 => 8
3 > 2 => TRUE
2 < 3 => TRUE
3 >= 3 => TRUE
2 <= 2 => TRUE
2 = 2 => TRUE
3 != 2 => TRUE

custom functions

DATEADD({Date}, [#], 'units')

Adds specified "count" units to a datetime. “Units” can be “days”, “months”, or “years.”

DATEADD({Date}, 10, 'days')
=> 10/9/2018 12:00am

Supported functions

Please see the Microsoft Excel function reference for detailed descriptions and examples of each supported function below.

ABS()
ACCRINT()
ACOS()
ACOSH()
ACOT()
ACOTH()
ADD()
AGGREGATE()
AND()
ARABIC()
ARGS2ARRAY()
ASIN()
ASINH()
ATAN()
ATAN2()
ATANH()
AVEDEV()
AVERAGE()
AVERAGEA()
AVERAGEIF()
AVERAGEIFS()
BASE()
BESSELI()
BESSELJ()
BESSELK()
BESSELY()
BETA.DIST()
BETA.INV()
BETADIST()
BETAINV()
BIN2DEC()
BIN2HEX()
BIN2OCT()
BINOM.DIST()
BINOM.DIST.RANGE()
BINOM.INV()
BINOMDIST()
BITAND()
BITLSHIFT()
BITOR()
BITRSHIFT()
BITXOR()
CEILING()
CEILINGMATH()
CEILINGPRECISE()
CHAR()
CHISQ.DIST()
CHISQ.DIST.RT()
CHISQ.INV()
CHISQ.INV.RT()
CHOOSE()
CHOOSE()
CLEAN()
CODE()
COLUMN()
COLUMNS()
COMBIN()
COMBINA()
COMPLEX()
CONCATENATE()
CONFIDENCE()
CONFIDENCE.NORM()
CONFIDENCE.T()
CONVERT()
CORREL()
COS()
COSH()
COT()
COTH()
COUNT()
COUNTA()
COUNTBLANK()
COUNTIF()
COUNTIFS()
COUNTIN()
COUNTUNIQUE()
COVARIANCE.P()
COVARIANCE.S()
CSC()
CSCH()
CUMIPMT()
CUMPRINC()
DATE()
DATEVALUE()
DAY()
DAYS()
DAYS360()
DB()
DDB()
DEC2BIN()
DEC2HEX()
DEC2OCT()
DECIMAL()
DEGREES()
DELTA()
DEVSQ()
DIVIDE()
DOLLARDE()
DOLLARFR()
E()
EDATE()
EFFECT()
EOMONTH()
EQ()
ERF()
ERFC()
EVEN()
EXACT()
EXP()
EXPON.DIST()
EXPONDIST()
F.DIST()
F.DIST.RT()
F.INV()
F.INV.RT()
FACT()
FACTDOUBLE()
FALSE()
FDIST()
FDISTRT()
FIND()
FINV()
FINVRT()
FISHER()
FISHERINV()
FLATTEN()
FLOOR()
FORECAST()
FREQUENCY()
FV()
FVSCHEDULE()
GAMMA()
GAMMA.DIST()
GAMMA.INV()
GAMMADIST()
GAMMAINV()
GAMMALN()
GAMMALN.PRECISE()
GAUSS()
GCD()
GEOMEAN()
GESTEP()
GROWTH()
GTE()
HARMEAN()
HEX2BIN()
HEX2DEC()
HEX2OCT()
HOUR()
HTML2TEXT()
HYPGEOM.DIST()
HYPGEOMDIST()
IF()
IMABS()
IMAGINARY()
IMARGUMENT()
IMCONJUGATE()
IMCOS()
IMCOSH()
IMCOT()
IMCSC()
IMCSCH()
IMDIV()
IMEXP()
IMLN()
IMLOG10()
IMLOG2()
IMPOWER()
IMPRODUCT()
IMREAL()
IMSEC()
IMSECH()
IMSIN()
IMSINH()
IMSQRT()
IMSUB()
IMSUM()
IMTAN()
INT()
INTERCEPT()
INTERVAL()
IPMT()
IRR()
ISBINARY()
ISBLANK()
ISEVEN()
ISLOGICAL()
ISNONTEXT()
ISNUMBER()
ISODD()
ISODD()
ISOWEEKNUM()
ISPMT()
ISTEXT()
JOIN()
KURT()
LARGE()
LCM()
LEFT()
LEN()
LINEST()
LN()
LOG()
LOG10()
LOGEST()
LOGNORM.DIST()
LOGNORM.INV()
LOGNORMDIST()
LOGNORMINV()
LOWER()
LT()
LTE()
MATCH()
MAX()
MAXA()
MEDIAN()
MID()
MIN()
MINA()
MINUS()
MINUTE()
MIRR()
MOD()
MODE.MULT()
MODE.SNGL()
MODEMULT()
MODESNGL()
MONTH()
MROUND()
MULTINOMIAL()
MULTIPLY()
NE()
NEGBINOM.DIST()
NEGBINOMDIST()
NETWORKDAYS()
NOMINAL()
NORM.DIST()
NORM.INV()
NORM.S.DIST()
NORM.S.INV()
NORMDIST()
NORMINV()
NORMSDIST()
NORMSINV()
NOT()
NOW()
NPER()
NPV()
NUMBERS()
OCT2BIN()
OCT2DEC()
OCT2HEX()
ODD()
OR()
PDURATION()
PEARSON()
PERCENTILEEXC()
PERCENTILEINC()
PERCENTRANKEXC()
PERCENTRANKINC()
PERMUT()
PERMUTATIONA()
PHI()
PI()
PMT()
POISSON.DIST()
POISSONDIST()
POW()
POWER()
PPMT()
PROB()
PRODUCT()
PROPER()
PV()
QUARTILE.EXC()
QUARTILE.INC()
QUARTILEEXC()
QUARTILEINC()
QUOTIENT()
RADIANS()
RAND()
RANDBETWEEN()
RANK.AVG()
RANK.EQ()
RANKAVG()
RANKEQ()
RATE()
REFERENCE()
REGEXEXTRACT()
REGEXMATCH()
REGEXREPLACE()
REPLACE()
REPT()
RIGHT()
ROMAN()
ROUND()
ROUNDDOWN()
ROUNDUP()
ROW()
ROWS()
RRI()
RSQ()
SEARCH()
SEC()
SECH()
SECOND()
SERIESSUM()
SIGN()
SIN()
SINH()
SKEW()
SKEW.P()
SKEWP()
SLN()
SLOPE()
SMALL()
SPLIT()
SPLIT()
SQRT()
SQRTPI()
STANDARDIZE()
STDEV.P()
STDEV.S()
STDEVA()
STDEVP()
STDEVPA()
STDEVS()
STEYX()
SUBSTITUTE()
SUBTOTAL()
SUM()
SUMIF()
SUMIFS()
SUMPRODUCT()
SUMSQ()
SUMX2MY2()
SUMX2PY2()
SUMXMY2()
SWITCH()
SYD()
T()
T.DIST()
T.DIST.2T()
T.DIST.RT()
T.INV()
T.INV.2T()
TAN()
TANH()
TBILLEQ()
TBILLPRICE()
TBILLYIELD()
TDIST()
TDIST2T()
TDISTRT()
TIME()
TIMEVALUE()
TINV()
TINV2T()
TODAY()
TRANSPOSE()
TREND()
TRIM()
TRIMMEAN()
TRUE()
TRUNC()
UNICHAR()
UNICODE()
UNIQUE()
UPPER()
VAR.P()
VAR.S()
VARA()
VARP()
VARPA()
VARS()
WEEKDAY()
WEEKNUM()
WEIBULL.DIST()
WEIBULLDIST()
WORKDAY()
XIRR()
XNPV()
XOR()
YEAR()
YEARFRAC()