Formula Functions

A list of all the formulas supported in calculated fields.

The formulas work like Excel and Google Sheets, and examples you find on the Internet will generally work in AllDrafts' calculated fields with little or no modification as lon gas you use field names instead of row-column references. (AllDrafts has no sense of cell D23, but may have a field named Interest Rate, which you can refer to in a formula by using the underscore (_) character for spaces, like Interest_Rate.)

Ultimately AllDrafts renders everything as text, but if a formula results in a number or date, AllDrafts will use the field's formatting property to render it.

ALLDRAFTS-ONLY FUNCTIONS

DATE

FINANCIAL

ENGINEERING

LOGICAL

MATH

STATISTICAL

TEXT