Automatic Progress Bar based on Checkboxes

1

Hi!
I would like to have a progress bar column in a table that automatically updates based on the checked boxes in another table.

So, basically, I created this dummy example;

“Action Tracker Table” has the general action points i need to work on.

“Action Itemised” below is a lookup of the above but grouped and check boxes to be able to add individual action points. Once I keep checking the boxes the column “Progress” in the first table automatically updates to reflect a % progress (so, calculates based on the number of checkboxes each action has)

I hope I am making sense and very grateful if someone could help me!

2

Hi @Miguel_Gomez

  • Start to find the finished checkbox in action itemised for current action with this formula

image
image883×661 43.7 KB

  • The same for total check, without the conditionning for check is true

image
image1111×541 36.7 KB

  • Progress bar will be Finished Check / Total Check, and enjoy !

CPT2211122156-1097x822

Is that what you wanted ?

Cheers,

Q.

1 Like
3

That’s perfect!
Thanks so much!!!

4

Be my guest, I entered it directly into your shared document (thanks for that btw, it’s 100x easier to understand and complete the issue you may have !)

2 Likes
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.