Customize Task Formulas

Here you can define the formulas that are used in your workspace.

• Name: The name of the property that will be displayed in the task properties editor.
• Display as: The type of the property, which can be one of the following:
  • Duration: A duration field.
  • Number: A numeric field.
• Formula: The formula that is used to calculate the value. See the examples below or go to the Formula Language documentation for more information about the formula language

Examples

Calculating ETA

The term ETA stands for estimated time of accomplishment, which is the estimated time it will take to deliver a task. You can calculate the ETA of a task by summing the estimation of all subtasks and the estimation of the task itself. You can use the following formula to calculate the ETA of a task:

sum(allBefore[todo].estimation, current[todo].estimation)

How does the formula work:

1. It sums
   1. All the tasks that are allBefore the current task (direct and indirect tasks) are have the status todo using the estimation property
   2. The current (but only if it’s still marked as todo) using the estimation property

Blocked Tasks Count

You can calculate the amount of tasks that are blocked by the current task by counting all the tasks that are blocked by the current task. You can use the following formula to calculate the amount of tasks that are blocked by the current task:

count(allAfter[todo])

How does the formula work:

1. It counts 2. The tasks that are allAfter (direct and indirect) the current task whose status is todo.