Start calculating data by creating simple or complex Formula Fields!

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.
• You can calculate Formula Fields on all paid plans.
• Individual Custom Fields can be hidden from guests.
• Guests with edit or full edit permissions can edit existing Custom Fields but cannot create new ones.
• Formula Fields that use the TODAY() function cannot be sorted, filtered, grouped, or used in Dashboard Calculation cards.
• You cannot calculate Formula Field columns if the Formula Field uses the TODAY() function.
• You must have access to all of the fields used in Formula Custom Fields to see the results. If a private field that you don't have access to is used, you won't see results.

Supported fields

With over 70 different functions, Formulas can calculate data using the following fields:

• Number Custom Fields
  

  You can use Number Custom Fields in Calculation cards. 

• Currency Custom Fields
• Dropdown Custom Fields that only use numbers
• Date Custom Fields
• Start Date
• Due Date
• Date Done
• Date Created
• Date Started
• Date Updated
• Date Closed
• Time Tracked
  • Time Tracked is in hours.
• Time Estimated
  • Time Estimated is in hours.
• Sprint Points
• Other Formula Fields

Create a simple Formula

Simple Formulas are meant for quick addition, subtraction, division, and multiplication.

To create a simple Formula from List view or Table view:

1. In the upper-right corner, click the plus icon.
2. Search for and select Formula.
3. Name the field, add permissions, and click Create.
4. Click the Formula Field.
5. Select a value from the first dropdown.
6. Select an operator:
   • Add
   • Subtract
   • Multiply
   • Divide
7. Select a value from the second dropdown.
8. Click Calculate.

Create an advanced Formula

Advanced Formulas allow for more complex and flexible calculations.

If enabled in your Workspace, you can ask ClickUp AI to write you an advanced Formula! Formulas with specific syntax requirements are complex, so results may vary. As we continuously refine ClickUp AI, accuracy will improve.

To create an advanced Formula from List view or Table view:

1. In the upper-right corner, click the plus icon.
2. Search for and select Formula.
3. Name the field, add permissions, and click Create.
4. Click the Formula Field.
5. Toggle on the Advanced Editor.
6. Search through the available Custom Fields and operators.
   

   You can combine multiple functions using the IF() and AND() operators.

7. Write a valid Formula in the text field at the top.
8. Click Calculate.

To make a Formula return a numeric value, add 1 * as a prefix to your Formula.

Show Formulas in tasks and views

After you've created a Formula, learn how to show its data in your tasks and views.

Formula options automatically calculate the entire column. Editing a Formula in one task edits the Formula for the entire column.

Add Formulas to new locations

Learn how to duplicate a Formula Field to use it in another location.