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?
Automatization progress number based on another table updates
+3
+10Hi,
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%
+31Yeap, 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
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.