Formula Fields allow you to make calculations between numeric, date, and time fields on tasks using simple or advanced Formulas. They can be applied at any level of your Workspace Hierarchy, but they are not transferable to other locations.
Formula options automatically calculate the entire column. Editing a Formula in one task edits the Formula for the entire column.
What you'll need
 60 uses of Custom Fields, including Formula Fields, are available on the Free Forever Plan.
 Unlimited uses are available on all paid plans.
 Individual Custom Fields can be hidden from guests.
 Guests with edit or full permissions can edit existing Custom Fields but cannot create new ones.
Create a Formula Field
To create a Formula Field in List view:
 Scroll all the way right and click the + icon.
 Select Formula.
 Name the Formula Field.
 Click Add Column.
Supported fields
With over 70 different functions, Formulas can calculate data using the following fields:
 Number Custom Fields
 Currency Custom Fields
 Dropdown Custom Fields that only use numbers
 Date Custom Fields
 Start Date
 Due Date
 Date Created
 Date Started
 Date Updated
 Date Closed
 Time Tracked
 Time Tracked is in hours.
 Time Estimated
 Time Estimated is in hours.
Simple Formulas
Simple Formulas are meant for quick addition, subtraction, division, and multiplication.
To create a simple Formula:
 Click your Formula Field.
 Select a value from the first dropdown.
 Select an operator:
 Add
 Subtract
 Multiply
 Divide
 Select a value from the second dropdown.
 Click Calculate.
Advanced Formulas
Advanced Formulas allow for more complex and flexible calculations.
To create an advanced Formula:
 Click your Formula Field.
 Toggle on the Advanced Editor.
 Search through the available Custom Fields and operators.
 Write a valid Formula in the text field at the top.
 Click Calculate.
Realworld examples
You can use advanced formulas to add or subtract days, show percent signs, round decimal places, and more! You can use advanced formulas to add or subtract days, show percent signs, round decimal places, and more!
Desired outcome  Method  Example formula 
Add a specific number of days to the date field.  Use the DATE function and apply basic mathematical expressions for YEAR(), MONTH(), OR DAY(). 
For example, to add seven days to a date:

Subtract a specific number of days from the date field.  Use the DATE function and apply basic mathematical expressions for YEAR(), MONTH(), OR DAY(). 
For example, to subtract five days from a date:

Calculate the difference between two dates.  Use the DAYS function to accomplish this. 
The following format is used for this formula:
To calculate the difference between a task's start and due date:

Calculate a percentage from a Custom Field.  Instead of decimals, use percentages in the formula. 
For example:

Colorcode results.  Use a formula to colorcode results with emojis. 
For example: • If the age of a task is 10 days or less, add a green indicator. • If the age of a task is 20 days or less, add a yellow indicator. • If the age of a task is over 20 days, add a red indicator. The following formula would achieve the intended result:

Add a percent sign.  Use the CONCATENATE function to add a percent sign. 
There are two ways to add a percent sign: • Use the CONCATENATE function: • Use &"%"to save time: Field names are casesensitive. 
Round decimal places on results.  Use the ROUND function to round results after using basic functions. 
The following format is used for this formula:
To add two number fields and round the result to the hundredth decimal place, use the following formula:
Field names are casesensitive. 
Updated