How do I add a calculation into a field for a "Project Status Report" ticket type?

[Bob Ramza]

PM here - limited JQL & coding skills to be up front.  I am a project admin, but not a JIRA admin, so limited security permissions.

I've set up a PMO dashboard to review all current projects in a Confluence dashboard, and have a follow up request.  I'd like to add an automation to calculate and populate the total of consumed hours on all tickets on each individual project board.

Currently, our "Consumed Hours" field is text-based, but is available on the dashboard.

To restate the question: Is there a way to automate a Tempo logged hours report & populate a field in the JIRA issue type "Project Status Report?"

[Bill Sheboy · Accepted solution]

Hi @Bob Ramza 

One way to do this is with automation rules.  Below is an example use case which walks through how to do this.  You may need your site admin to add a custom field for you if you do not already have a location/field to store the sum of any values.

https://community.atlassian.com/t5/Automation-articles/How-to-sum-up-logged-hours-using-automation-in-Jira-Cloud/ba-p/1409115

Best regards,

Bill

[Bob Ramza]

Thank you, Bill! 

I've reviewed the link with our practice lead, and we're investigating how to implement across the organization.

If we have any follow up questions, I will reach back out.

Have a great day,

Bob

[Bill Sheboy]

Hi, Bob. 

Glad to hear that.  If this ends up helping you, please consider marking this question as answered.  That helps others in the future find solutions faster.  Thanks!