With formula fields, you can easily make calculations between numeric custom fields on a task. Automatically determine things like the cost of a new product order or scoring for a new lead.

Formula custom fields allow you to calculate other custom fields using both simple and advanced formulas. 

Imagine that you have an "hours worked" custom field along with an "hourly cost" custom field. With Formulas, you can multiple these together to get the total "cost" or "budget". 

With over 70 different functions, formulas currently work with these custom fields: 

  1. Number fields
  2. Currency field
  3. Dropdowns that only use numbers

Coming Soon

This release is just a taste of what's to come! We plan on adding a lot more functionality, including...

  • Calculated columns (sum, average, range)
  • Additional support for Task and Custom Fields (date, string, estimates,...)
  • More functions

Simple formula

The simple version of formula fields is meant for quick calculations of values. To create a simple formula: 

  1. Select the first value from the dropdown
  2. Select an operator (multiply, divide, add, subtract)
  3. Select a second value
  4. Click Calculate  

Advanced formula

For those looking for a bit more flexibility, advanced formulas can be enabled by flipping the switch in the bottom corner of the formula options. To create an advanced formula: 

  1. Search through the list of available custom fields and operators
  2. Write any valid formula
  3. Click Calculate  

Note:

  • Formula Fields can be applied at any level but are not transferable to other locations.
  • Formula options automatically calculate on the entire column; editing a formula in one task edits the formula for the entire column.

Supported advanced functions

We support many of the common functions used in your favorite spreadsheet application! Additional documentation can be found in app when building your formula.

  • DATE
  • DAY
  • DAYS
  • EDATE
  • EOMONTH
  • HOUR
  • MINUTE
  • MONTH
  • NETWORKDAYS
  • NOW
  • TODAY
  • WEEKDAY
  • YEAR
  • WEEKNUM
  • WORKDAY
  • AND
  • IF
  • IFS
  • IFERROR
  • NOT
  • OR
  • SWITCH
  • XOR
  • COS
  • ISEVEN
  • LOG
  • MOD
  • POWER
  • PRODUCT
  • QUOTIENT
  • RANDBETWEEN
  • ROUND
  • ROUNDDOWN
  • ROUNDUP
  • SIN
  • SQRT
  • SUM
  • SUMIF
  • SUMIFS
  • SUMPRODUCT
  • TAN
  • TRUNC
  • AVERAGE
  • AVERAGEIF
  • AVERAGEIFS
  • COUNT
  • COUNTBLANK
  • COUNTIF
  • COUNTIFS
  • COUNTUNIQUE
  • LARGE
  • MAX
  • MEDIAN
  • MIN
  • SMALL
  • CHAR
  • CLEAN
  • CONCATENATE
  • EXACT
  • FIND
  • LEFT
  • LEN
  • LOWER
  • MID
  • PROPER
  • REGEXEXTRACT
  • REGEXMATCH
  • REGEXREPLACE
  • REPLACE
  • RIGHT
  • SEARCH
  • SPLIT
  • TRIM
  • UPPER
Did this answer your question?