Automatization progress number based on another table updates

[furucia2023]

Hello everyone!
I'm a project manager tracking OKR progress based on milestone achievement. I currently have two tables in Airtable: one for tasks (where I have recorded the milestones) and one for OKR (where I have included a progress field). Both tables are joined so that each task has one or several OKRs assigned to it. So what I want to achieve is that once I complete a task (modify its status as closed) it automatically updates the progress percentage in the progress field in my OKR table. Does anyone have any recommendations on how I can do this?

[RdMedia_srl]

Hi, 

I don't know your table structure, but you could have something like this

Task table with a % complete field for each single task

this is field

and the the other OKR table with your single GOAL and related task, here you will have a ROLLUP "Completion" field

this is the field that automatically will do the "average" of all the tasks "completion" values...

Of course than, if you need, you can trigger an automation when record of this table match some conditions like "Completion %" field is 100%

[TheTimeSavingCo]

Yeap, you can do this with:
1. "Count" field that only counts linked tasks that have a status of "Closed"
2. "Count" field that counts all linked tasks
3. "Formula" field that divides the field from step 2 by the one from step 3

Link to base