Add % of Completion for related objective

Hey team,

I think this is an easy one, just need some help.

I have two tables - Objectives and Steps. Each step within the objective has a different “weight” / percentage tied to it, based on its importance. I need to add up the % of completion within each objective based on the weight of each step, since each step is not equal in value.

Objectives table:

Steps Table:

So ultimately I would see on the Objectives tab the % of completion based on the steps “checked” in the Steps table

If I’m understanding correctly, you can use a Rollup field for that (same field type as ‘Objective Team’). The solution below isn’t totally correct, but hopefully it demonstrates the idea. I’m cheating a little by only counting weights that are 100% complete. A better solution would probably involve a third percentage column (a formula field) that combines weight with percent complete.


Got it!

Thanks for the help!!

image012.jpg

image013.png

image014.jpg

image015.png

image016.jpg

image017.jpg

image018.jpg

image019.png

image020.png