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.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.