As operations and development teams we want to see the sum of a custom field for all linked tickets.
Scenario: Custom field Ticket Value on JSM Project has a value of 10 on issue JSM-1 and a value of 13 on issue JSM-2.
A development ticket is created on DEV project; JSM-1 and JSM-2 are linked to DEV-1.
Total Ticket Value should on DEV-1 will have the sum of Ticket Value on JSM-1 and JSM-2: 23.
Total Ticket Value is a calculated field using JSU's Jira Suite Utility Calculated Field feature with the following formula:
sum(linkedIssues('Blocks',"Ticket Value"))++sum(linkedIssues('Relates',"Ticket Value"))+sum(linkedIssues('Duplicate',"Ticket Value"))
IRL the value is not being populated on DEV-1. I would an automation with {{lookupissues}} but custom fields are not available properties of the results. Ideas and suggestions would be greatly appreciated.
TMW you finally get done creating a detailed community post only to be suggested a related post with nearly an identical subject...
https://community.atlassian.com/t5/Jira-Software-questions/Calculate-the-Sum-of-custom-field-across-projects/qaq-p/1508087
Going to see if the above works.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.