Hello! We are using Airtable for a project plan, where we have one table with tasks and one table with milestones (several tasks are linked to each milestone). We would like to calculate the percentage of tasks completed for each milestone in the milestone table, so we can quickly see that for a specific milestone e.g. 70% of the tasks in the task table have a status of ‘complete’. Thanks in advance for your help!
Solved
Milestones and tasks - calculating completion %
Best answer by ScottWorld
Hi Adam, thank you so much for putting this together, this is exactly what I’m looking for! Would you mind please sharing the formula you used for the completion % column?
After creating your formula field with this formula:
{Tasks completed} / {Total tasks}
You will also need to go to the “formatting” tab of that formula field to display your formula results as a percentage, and with the right number of decimal points.
+31Hi Emma, I’ve put something together for you here that should do what you’re looking for
Uses conditionals to get the count of completed tasks and calculates the percentage from there
Hi Emma, I’ve put something together for you here that should do what you’re looking for
Uses conditionals to get the count of completed tasks and calculates the percentage from there
Hi Adam, thank you so much for putting this together, this is exactly what I’m looking for! Would you mind please sharing the formula you used for the completion % column?
+31Hi Adam, thank you so much for putting this together, this is exactly what I’m looking for! Would you mind please sharing the formula you used for the completion % column?
Sure, it’s {Tasks completed}/{Total tasks}
For future reference, you can duplicate a base to get all the formulas too!
Glad I could help!
+35Hi Adam, thank you so much for putting this together, this is exactly what I’m looking for! Would you mind please sharing the formula you used for the completion % column?
After creating your formula field with this formula:
{Tasks completed} / {Total tasks}
You will also need to go to the “formatting” tab of that formula field to display your formula results as a percentage, and with the right number of decimal points.
+3Hi there, I need the exact same thing!
I created my Milestones on the same table as my Tasks, using the Gantt view, and then linked each task to its corresponding Milestone by using a linked field.
From reading above, it sounds like I should NOT use the Milestones on the Gantt view and should create another table with Milestones and link from there. Is that correct?
+3Hey there, this is exactly what I was looking for as well. But how did you calculate the total tasks and completed tasks? I also don't have the tasks in one row/field but have every tasks in a different row. How would it be possible then?
Thanks!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.