Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Excerpt
hiddentrue

Create formulas using duration fields e.g Original estimate * hourly rate.


Table of Contents:

Table of Contents
maxLevel2

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.


Image RemovedImage Added


Expand
titleWatch duration sum formula tutorial video...


Align
aligncenter

Widget Connector
width889
urlhttps://www.youtube.com/watch?v=uR74XuFYJ8k
height500





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. 


Image RemovedImage Added


Expand
titleWatch duration multiplier formula tutorial video...


Align
aligncenter

Widget Connector
width889
urlhttps://www.youtube.com/watch?v=5sfw6xXjir4
height500





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.


Image RemovedImage Added


Expand
titleWatch sub-task rollup to issue formula tutorial video...


Align
aligncenter

Widget Connector
width889
urlhttps://www.youtube.com/watch?v=3_pP-GG0p6k
height500





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

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



Image RemovedImage Added


Expand
titleWatch issue rollup to epic formula tutorial video...


Align
aligncenter

Widget Connector
width889
urlhttps://www.youtube.com/watch?v=j-wLBcA16DA
height500






Info
titleMissing 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.