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

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