Templates

Assignee's groups

Advanced text formula

List of all groups the assignee of the current work item belongs to.

Count assignee changes

Advanced number formula

Number of times that the assignee of the current work item was changed.

Last assignee change author

Advanced text formula

Name of the last user who changed the Assignee field.

Parent assignee

Advanced text formula

Name of the assignee in the parent of the current work item.

Previous assignee

Advanced text formula

Name of the previous assignee in the current work item.

Attachment authors

Advanced text formula

Display name of the authors of the attachments in the current work item.

Attachment filenames

Advanced text formula

Names of attachments of the current work item.

Attachment MIME types

Advanced text formula

List of MIME types of attachments of the current work item.

Count attachment authors

Advance number formula

Number of users who added an attachment in the work item.

Count attachments

Advanced number formula

Number of attachments in the current work item.

Total attachment size in MB

Advanced number formula

Sum of the size in MB of all attachments in the current work item.

Comment authors

Advanced text formula

List of names of all comment authors of the current work item.

Count comment authors

Advanced text formula

Number of users who have authored a comment in the work item.

Count comments

Advanced text formula

Number of comments in the current work item.

First comment

Advanced text formula

Text of the first comment in the current work item.

First comment author

Advanced text formula

Name of the author of the first comment of current work item.

Last comment

Advanced text formula

Text of the last comment in the current work item.

Last comment author

Advanced text formula

Name of the author of the last comment of the current work item.

Count work items and sub-tasks in epic

Advanced number formula

Number of work items and their sub-tasks in the current epic.

Count work items in epic

Advanced number formula

Number of child work items in the current epic excluding sub-tasks.

Creation date of parent epic

Advanced text formula

Creation date of the parent epic of the current work item.

Sum Story points in linked Epic

Advanced number formula

Sum of story points from work items in the same epic as the current item.

Time spent in epic and its children

Advanced number formula

Sum of the time spent in the current epic and its child work items.

ICE score

Advanced number formula

Multiplication of the Impact, Confidence and Ease parameters of the current work item.

Sum completed child items' story points

Advanced number formula

Sum of story points from completed items whose parent is the current work item.

Sum completed sibling items’ story points

Advanced number formula

Sum numeric field values exclusively from the completed sibling work items.

Sum original estimates under parent

Advanced number formula

Return the sum of the original estimates of the work items under the epic's parent in hours only in the epic's parent view.

Sum remaining estimate in epic

Advanced number formula

Sum of the remaining estimate of the work items in the current epic.

Sum remaining estimate in epic, incl. sub-tasks

Advanced number formula

Sum of the remaining estimate of the work items and their sub-tasks in the current epic.

Time spent in linked work items

Advanced number formula

Sum of the time spent in the work items linked to the current work item.

Time spent in the current and linked work items

Advanced number formula

Sum of the time spent in the current and linked work items.

Time spent ratio

Advanced number formula

Percentage of the original estimate already logged as time spent.

Count incoming links

Advanced number formula

Number of inward work item links leading to the current work item.

Count outgoing links

Advanced number formula

Number of outward links stemming from the current work item.

Count unresolved blocking work items

Advanced number formula

Number of unresolved work items linked to the work item with “is blocked by”.

Count work item links

Advanced number formula

Number of work item links in the current work item.

Count components

Advanced number formula

Number of components in the current work item.

Count labels

Advanced number formula

Number of labels in the current work item.

Email addresses in work item description

Advanced text formula

List of all email addresses mentioned in the work item description.

Months elapsed

Advanced number formula

Months elapsed from the date in a selected field until today.

Timely resolution assessment

Advanced text formula

Assessment of whether the resolution was set before the due date.

Work item ID

Advanced text formula

ID of the current work item.

Work type description

Advanced text formula

Description of the work type of the current work item.

Parent priority

Advanced text formula

Priority of the parent of the current work item.

Priority description

Advanced text formula

Description of the priorityin the current work item.

Project category

Advanced text formula

Name of the project category of the current work item’s project.

Project description

Advanced text formula

Description of the current work item’s project.

Project lead

Advanced text formula

Name of the project leadof the current work item’s project.

Parent reporter

Advanced text formula

Name of the reporter in the parent of the current work item.

Previous reporter

Advanced text formula

Name of the previous reporter in the current work item.

Count changes to current status

Advanced number formula

Number of times that the current work item was changed to the current status.

Count open child items

Advanced number formula

Number of open work items whose parent is the current work item.

Count status changes

Advanced number formula

Number of times that the status was changed in the current work item.

Count work item rejections

Advanced number formula

Number of times that the current work item was rejected.

Days in previous status

Advanced number formula

Number of days that the current item spent in the previous status.

Last status change author

Advanced text formula

Name of the last user who changed the status of the current work item

Parent status

Advanced text formula

Status of the parent of the current work item.

Previous status

Advanced text formula

Name of the previous status that the work item was in.

Status description

Advanced text formula

Description of the status of the current work item.

Components from all sub-tasks

Advanced text formula

List of the components in the sub-tasks of the current work item.

Count attachments in sub-tasks

Advanced number formula

Number of attachments in the sub-tasks of the current work item.

Count sub-tasks

Advanced number formula

Number of sub-tasks of the current work item.

Percentage of resolved child work items

Advanced text formula

Percentage of child work items with a resolution.

Sub-task assignees

Advanced text formula

List of assignees of the sub-tasks of the current work item.

Sub-task labels

Advanced text formula

Labels of the sub-tasks of the current work item.

Sub-task reporters

Advanced text formula

List of names of the reporters in the sub-tasks of the current work item.

Count affected versions

Advanced number formula

Number of affected versions in the current work item.

Count fix versions

Advanced number formula

Number of fix versions in the current work item.