Formula Fields allow you to make calculations between numeric, date, and time fields on tasks using simple or advanced Formulas.
From calculating the number of days between start and due dates, differences between Custom Fields, or more complex calculations, use Formula Fields to figure out additional information that will enrich your ClickUp experience.
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.
Create a Formula Field
Learn how to create a Formula Field.
Advanced Formula types
Learn about using the following functions in your advanced Formulas:
Show Formulas in tasks and views
Show Formula 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.
Use Formulas in Formulas
You can use other Formula Fields as variables in your simple and advanced Formulas!
When creating a new Formula, there is no limit to the number of other Formulas you can use in its definition, and you can mix and match with other numeric fields like Numbers and Dates.
Nested Formulas cannot currently exceed one layer. For example, a Formula that is defined using another Formula cannot be used to define a third Formula.
Sort and filter tasks by Formula Fields
Learn how to sort and filter tasks by Formula Fields.
You cannot filter tasks by Formula Fields that contain the TODAY() function or return multiple output types.
Group tasks by Formula Fields
You can group tasks by Formula Fields in List view and Table view.
You can only group tasks by Formula Fields that output dates, booleans, or a mix of dates and booleans.
Calculate Formula columns
You can calculate Formula Field columns in List view on all paid plans.
You can only calculate columns for Formula Fields that output numbers and dates.
Set Formula Field permissions
Choose who can interact with individual Custom Fields.
Advanced Formula use cases
Check out our list of real-world, popular Formulas that you can start using in your workflows.
Formula Field limits
The following actions are not supported with Formula Fields:
-
Formula Fields do not support using Custom Fields that contain text.
-
Formula Fields that use the
TODAY()function cannot be sorted, filtered, or grouped. -
You cannot calculate Formula Field columns if the Formula Field uses the
TODAY()function. -
You cannot calculate a sum of values from linked fields using a Formula.
Unexpected Formula results
If your Formula is not calculating the expected result, try the following:
- Open the Formula editor and ensure the Formula is referencing the correct fields.
- If your Formula Field has the same name as another Custom Field, ensure you are using the Formula Field by checking its field type in the Custom Field Manager.
- Consider using ClickUp AI to write the Formula for you by stating what you want the Formula to do.
- If you've checked your Formula and believe the syntax is correct, please contact Support by clicking the chat bubble icon in the lower-right corner of your screen.
- Remove filters from the view or Dashboard. If this corrects the calculation, please contact Support.