# \[DONE\]Progress bar for project management

**URL:** <https://community.fibery.io/t/done-progress-bar-for-project-management/4053>\
**Category:** Get Help\
**Created:** [February 24, 2023, 12:27pm UTC](https://community.fibery.io/t/done-progress-bar-for-project-management/4053 "2023-02-24T12:27:55Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Marloes](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/marloes/32/5926_2.png) [@Marloes](https://community.fibery.io/u/Marloes)\
**Post date:** [February 24, 2023, 12:27pm UTC](https://community.fibery.io/t/done-progress-bar-for-project-management/4053/1 "2023-02-24T12:27:55Z")

</div>

Hi all,

For managing projects I use a progress bar to see what the progress of a project is. The only thing I’m running up against is that it’s only checking for tasks, not for subtask or sub-subtasks, etc.  
This is the formula I’m using: (Taken.Filter(State.Name = “Done”).Count() / Taken.Count()) \* 100

The same goes up for the "Number of tasks left to complete.  
This is the formula I’m using: Taken.Filter(State.Name != “Done”).Count()

Is there a way to change the formula to make the formula checking for all levels of tasks inside the same project?

Thanks!

---

<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:** [February 24, 2023, 1:13pm UTC](https://community.fibery.io/t/done-progress-bar-for-project-management/4053/2 "2023-02-24T13:13:15Z")

</div>

You can probably do it by using a recursive formulas on the Task db level.

So if the Project contains Tasks, and Tasks are self-related (one-to-many) you might want to do something like this:

![firefox_4OQZWVUG43](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/4/45ec7d751292bcddeaa0668213b656d46bc01196.gif)

Note: to create a formula that refers to itself in a related entity, you need to create the formula field first (with some dummy value of the correct data type) and then re-open it and edit to refer to itself.  
The autocompletion will not propose the field name though, so you have to type it manually - you will know if you got it right because the red underline will disappear.  
 ![firefox_A2pRVTUzrN](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/0/0735cf740b1fd9b2a1e8329e45ec837d4c204d68.gif)

---

<div class="post-metadata">

**Author:** ![Marloes](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/marloes/32/5926_2.png) [@Marloes](https://community.fibery.io/u/Marloes)\
**Post date:** [February 24, 2023, 1:16pm UTC](https://community.fibery.io/t/done-progress-bar-for-project-management/4053/3 "2023-02-24T13:16:54Z")

</div>

Thanks for your fast reply! I will implement this.

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:** [October 4, 2024, 3:35pm UTC](https://community.fibery.io/t/done-progress-bar-for-project-management/4053/4 "2024-10-04T15:35:24Z")

</div>