Skip to main content

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.



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!!