Skip to main content

Custom Formula Fields

Learn how to create, add, and use custom formula fields in Productive.

Updated this week

In Productive, most data has a dedicated field, but sometimes you need a calculation that isn’t available by default. That’s where custom formula fields come in.

Formulas allow you to combine multiple fields using simple mathematical operations.

They are available for all numeric data across Productive, so you can create your own metrics and calculations directly in views and reports.

How to Create a Custom Formula

1) Add a new formula field

  • Click on Fields > Add Formula.

2) Name your field

  • Give it a clear, descriptive name (e.g., Remaining time).

3) Choose values

  • Type @ to display a dropdown with available fields.

  • Combine them with supported operations:

    • Addition (+)

    • Subtraction (-)

    • Multiplication (*)

    • Division (/)

  • Use brackets for clarity, e.g. (A - B) * C.

Number Formats in Formulas

When using formulas, keep in mind how different units are stored in Productive:

  • Money values are counted in cents.

    • Example: Writing 100 will be calculated as 1.00. To represent 100.00, you need to enter 10000.

  • Time values are counted in minutes.

    • Example: Writing 100 will be calculated as 100 minutes, not hours.

Understanding these units ensures your formulas calculate correctly.

Example Use Case

Let’s say you want to track the difference between the estimated time for a project and the actual worked time.

  • Formula: @Estimated time – @Worked time

  • Field name: Remaining time


  • Once you’ve set this up, click Create Field to add it to your view. The column will now show the remaining time per project or task.

Composite Formulas

You can also create composite formulas, which combine multiple custom formulas into a single field.

For example:

  • Formula 1: Internal Time

  • Formula 2: Client Time

  • Composite Formula: Total Time = Internal + Client

This allows you to build more complex calculations step by step.

Controlling How Totals Are Calculated

When working with formula fields in table views and reports, you can adjust how totals are displayed in the column header. The three available options are:

  • Default – applies the formula row by row

  • Sum – calculates totals once at the header level

  • Average – shows an average across rows

👉 Learn more about these options in Calculation Options: Default, Sum, and Average

Did this answer your question?