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!