Jan 11, 2023 01:40 PM
Prefacing this by saying I'm still a novice with Airtable.
My base has tables for Tasks. The Task table has both a Grid and Gantt view. On the Gantt view I set Miletones, and then on the Grid view I linked each task with it's corresponding Milestone.
I would like to provide a view that shows the percentage of completed tasks associated with a Milestone. The idea being that you would be able to see the progress towards the Milestone.
I'm not sure how to do it, and I'm wondering if I built the base incorrectly.
Jan 11, 2023 03:30 PM
Hi stillwell,
It seems like you have gotten pretty far along on your own, congrats!
This is how I would do it...
First, I am assuming your tables look something like this.
(Tasks)
(Milestones)
*Note that you should be using the 'Link to...' field type to connect your task records to your milestones*
Then in your Milestones table you should be able to see each of the tasks now associated in the automatically generated 'Link to Task' field. When you create this field, it should look like this.
You will also want to create a 'Done' Field for each Task using a checkbox field type in the Task's Table.
Then in your Milestones Table you will need to create three new fields: '# of tasks', '# of tasks completed', '% completed' (named 'Calculation' on my screenshot above)
These three fields will look like this:
That is pretty much it! Note that if you have named things differently, that will effect how certain menus appear on your screen. I have highlighted all of times I used names that might be different than what you see on your screen.
You should then be able to take the % completed information into any and all views you want!
Let me know if you have any other questions.