Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Add % of Completion for related objective

Topic Labels: Formulas
331 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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:
image

Steps Table:

image

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

image

2 Replies 2

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.

steps
objectives

Got it!

Thanks for the help!!

image011.jpg

image012.jpg

image013.png

image014.jpg

image015.png

image016.jpg

image017.jpg

image018.jpg

image019.png

image020.png