# Sprint Board with Calculated Estimates roll-up

**URL:** <https://community.fibery.io/t/sprint-board-with-calculated-estimates-roll-up/3539>\
**Category:** Get Help\
**Created:** [November 14, 2022, 10:22pm UTC](https://community.fibery.io/t/sprint-board-with-calculated-estimates-roll-up/3539 "2022-11-14T22:22:30Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![B\_Sp](https://avatars.discourse-cdn.com/v4/letter/b/e8c25b/32.png) [@B\_Sp](https://community.fibery.io/u/B_Sp)\
**Post date:** [November 14, 2022, 10:22pm UTC](https://community.fibery.io/t/sprint-board-with-calculated-estimates-roll-up/3539/1 "2022-11-14T22:22:30Z")

</div>

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 have.

Before I create a feature request for this, could you let me now if this is actually possible now?

This is similar to [Reported Objects count incorrect in boards](https://community.fibery.io/t/objects-count-in-board-to-indicate-true-number-of-entities-in-respective-column-currently-as-of-oct-2022-does-not-work/3540), in that this is a typical feature of kanban boards that would be great to have in Fibery for software teams. Thank you!

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [November 15, 2022, 8:32am UTC](https://community.fibery.io/t/sprint-board-with-calculated-estimates-roll-up/3539/2 "2022-11-15T08:32:17Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![mwatkins](https://avatars.discourse-cdn.com/v4/letter/m/ba8739/32.png) [@mwatkins](https://community.fibery.io/u/mwatkins)\
**Post date:** [November 15, 2022, 5:06pm UTC](https://community.fibery.io/t/sprint-board-with-calculated-estimates-roll-up/3539/3 "2022-11-15T17:06:51Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![B\_Sp](https://avatars.discourse-cdn.com/v4/letter/b/e8c25b/32.png) [@B\_Sp](https://community.fibery.io/u/B_Sp)\
**Post date:** [November 15, 2022, 6:34pm UTC](https://community.fibery.io/t/sprint-board-with-calculated-estimates-roll-up/3539/4 "2022-11-15T18:34:09Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![mwatkins](https://avatars.discourse-cdn.com/v4/letter/m/ba8739/32.png) [@mwatkins](https://community.fibery.io/u/mwatkins)\
**Post date:** [November 15, 2022, 9:12pm UTC](https://community.fibery.io/t/sprint-board-with-calculated-estimates-roll-up/3539/5 "2022-11-15T21:12:44Z")

</div>

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, which means that what you’re seeing isn’t actually a rollup of what’s displayed in the column.

Apologies if these are two separate issues and I misunderstood.

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [November 16, 2022, 7:07am UTC](https://community.fibery.io/t/sprint-board-with-calculated-estimates-roll-up/3539/6 "2022-11-16T07:07:44Z")

</div>

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 calculations, but no ETA I’m aftaid.

---

<div class="post-metadata">

**Author:** ![B\_Sp](https://avatars.discourse-cdn.com/v4/letter/b/e8c25b/32.png) [@B\_Sp](https://community.fibery.io/u/B_Sp)\
**Post date:** [November 18, 2022, 6:48am UTC](https://community.fibery.io/t/sprint-board-with-calculated-estimates-roll-up/3539/7 "2022-11-18T06:48:31Z")

</div>

Thanks @Chr1sG. Would that item in the backlog you mention solve [Reported object count is incorrect](https://community.fibery.io/t/board-columns-reported-object-count-is-incorrect/2508)?

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [November 18, 2022, 7:55am UTC](https://community.fibery.io/t/sprint-board-with-calculated-estimates-roll-up/3539/8 "2022-11-18T07:55:13Z")

</div>

I hope so 🤞
