I would like to be able to see on the top of columns I use on a Board to represent a Sprint a total of estimated hours in the stories in the respective column. Jira has a very useful feature where it will automatically calculate the total hours as you add issues to a specialized Sprint Board they h…

It sounds like you should add a formula field to calculate the total hours, and then enable that field in board view… or have I missed something?

I tried to do a similar thing and hit a wall because the formula doesn’t seem to have a way to incorporate the filters in place on the board, so the calculation was incorrect.

Yes, like @mwatkins I don’t see the formulas as available fields on the columns - which in this case were the “state.” Thanks!

You actually can add fields to the columns! You have to open the column as an entity, then you can create a formula field and select to display it in the board view. But when you create those formula fields, it doesn’t seem like you can apply the filters you set on the board view within the formula…

The State field (and all single or multi select fields) are in fact databases, just hidden from the space configuration. As you noted, it is possible to add fields (including formulas) to them. Such formulas are not view-specific though. We have in the backlog a feature to allow view-specific calc…

Sprint Board with Calculated Estimates roll-up

Get Help

B_Sp November 18, 2022, 6:48am 7

Thanks @Chr1sG. Would that item in the backlog you mention solve Reported object count is incorrect?

Topic		Replies	Views
Aggregate totals / limits in Columns in Board view Ideas & Features	4	929	August 6, 2020
Summary values for rows and columns in Board view Ideas & Features	1	502	February 22, 2022
In Boards, Sub-Fields at Column/Row intersections Ideas & Features	7	643	March 1, 2025
Kanban view columns & formulas Ideas & Features	3	416	December 13, 2022
Calculate lookups on the front end (based on filters) Ideas & Features	5	78	February 13, 2025

Sprint Board with Calculated Estimates roll-up

Related topics