Use advanced Formulas

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:

  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. In the Advanced Editor type an advanced 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.

 

Was this article helpful?