Duration Formulas

Created by Vincent Mutambuki

Table of Contents:

Requirements:

  • One "Text Field (single line)" custom field to store your results.
  • Single line text field supported for calculations. User must make sure that the entered duration value used for calculation has *w, *d, *h, or *m ( representing weeks, days, hours and minutes - where * can be any number. For examples: 4d, 5h 30m, 60m, and 3w.) appended to the duration number. 



Duration Add and Subtract

Add or Subtract two duration numbers together from System duration fields, custom fields, or static numbers to create a new duration.

  1. Enter your custom Formula Name.
  2. Select an existing duration field to be summated to.
  3. Select + or - to either add or subtract that duration.
  4. Enter in a duration amount to sum to the field you selected or enter "@" to choose from custom duration fields within your project.
  5. Select a result field for the calculation of your formula.
  6. The "Save Formula" button saves the formula once you are finished editing it.


 Watch duration sum formula tutorial video...


Duration Multiplier & Divider

Multiply or divide a duration from System duration fields, custom fields, or static numbers; with a number or another duration field.

  1. Enter your custom Formula Name.
  2. Select an existing duration field.
  3. Select either multiply or divide.
  4. Enter in a duration amount to multiply or divide the field you selected or enter "@" to choose from another custom duration field within your project.
    1. To use a negative duration place a "-" before the number.
  5. Select a result field for the calculation of your formula.
  6. The "Save Formula" button saves the formula once you are finished editing it.

     It is important to note that duration multiplier & divider formulas calculate results in terms of hours only. 


 Watch duration multiplier formula tutorial video...


Sub-Task Rollup to Issue

Sum up a single duration field from your sub-task custom field and store the results in the parent issue.

  1. Enter your custom Formula Name.
  2. Select the custom Sub-Task field you want to roll up into the parent issue.
  3. Select the mathematical function you want to perform with this field.
  4. Select a result field for the calculation of your formula.
  5. The "Save Formula" button saves the formula once you are finished editing it.


 Watch sub-task rollup to issue formula tutorial video...


Issue Rollup to Epic

Sum up a single duration field from your issue custom fields and store the result in an Epic.

  1. Enter your custom Formula Name.
  2. Select the custom issue field you want to roll up into the Epic issue.
  3. Select the mathematical function you want to perform on the field.
  4. Select a result field for the calculation of your formula.
  5. The "Save Formula" button saves the formula once you are finished editing it.

An "Epic Link" field is required for the calculation to run on the child tickets.


 Watch issue rollup to epic formula tutorial video...


Missing Fields?

If after adding a custom fields you wish to use to the project's Create and Edit Screens they should be available to be used in the formula as long as they are of a compatible custom field type. If the Custom fields do not appear as options when editing the formula then attempt to refresh the available custom fields by; navigating to the top right of the  screen, clicking on the gear icon, and selecting the option "Refresh custom fields". Now the custom fields you've added should be available to use while editing your formulas.


Write into our Support Desk with any questions you have.