Help

Automatization progress number based on another table updates

Topic Labels: Automations
399 2
cancel
Showing results for 
Search instead for 
Did you mean: 
furucia2023
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

2 Replies 2
RdMedia_srl
7 - App Architect
7 - App Architect

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

Schermata 2023-04-15 alle 12.52.33.png

this is field

Schermata 2023-04-15 alle 12.52.40.png

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

Schermata 2023-04-15 alle 12.55.08.png

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

Schermata 2023-04-15 alle 12.55.14.png

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

 


Rodolfo - RdMedia

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

Screenshot 2023-04-15 at 8.37.04 PM.png

Screenshot 2023-04-15 at 8.37.08 PM.png

Link to base