Use advanced Formulas to make calculations in ClickUp.

# 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:

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

To make a Formula return a numeric value, add

as a prefix to your Formula.**1 ***

## 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.

# Date and time functions

Use advanced Formulas to make calculations using date and time functions.

# String functions

Use advanced Formulas to make calculations using string functions.

# Logic functions

Use advanced Formulas to make calculations using logic functions.

# Mathematical functions

Use advanced Formulas to make calculations using mathematical functions.