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.
• Formula Fields do not support using Custom Fields that contain text.

Create an advanced Formula

To create an advanced Formula from List or Table view:

1. In the upper-right corner above the task table, click the plus icon.
2. Select Formula.
3. Name the Formula Field.
4. Click Create.
5. From the new Formula column, click the ƒx symbol.
6. Click the Advanced Editor toggle.
7. Type a formula and press Calculate.

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

Ask ClickUp AI to write an advanced Formula

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.

Use Formulas in Formulas

You can use other Formula Fields as variables in your 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.