I’m working on a Notion database for project management. I’ve got a main project with two subprojects, each having their own tasks. I added a Completion column, but I’m running into some issues.
Right now, when I mark all tasks as Done, the main project’s completion stays empty instead of showing 100%. Also, I’d like to give different weights to the subprojects. For example, making Subproject A worth 40% and Subproject B worth 60% of the total.
I tried using a Formula column, but I’m stuck. The Notion docs aren’t much help either. Any ideas on how to set this up? I’m pretty new to Notion formulas, so a simple explanation would be great.
Here’s a quick example of what I’ve got so far:
Main Project
|- Subproject A (want it to be 40%)
|- Task 1 (Done)
|- Task 2 (Done)
|- Subproject B (want it to be 60%)
|- Task 1 (Done)
How can I make this work the way I want? Thanks for any help!
hey Nova56, i’ve got a trick for ya. instead of using formulas, try relations between databases. link ur main project to subprojects, then use rollup properties to calc completion. for weights, multiply rollups by 0.4 and 0.6 in main project formula. it’s easier than it sounds, trust me!
I’ve encountered this issue before, and here’s a solution that might work for you:
Create a separate database for tasks and link it to your projects database. In the tasks database, add a checkbox property for completion status. Then, in your projects database, use a rollup property to count completed tasks and another for total tasks.
For the main project, you can use a formula like this:
(prop(“Subproject A Completion”) * 0.4) + (prop(“Subproject B Completion”) * 0.6)
Where “Subproject A/B Completion” are rollup properties calculating (Completed Tasks / Total Tasks) * 100 for each subproject.
This approach gives you flexibility to adjust weights and add more subprojects later. It takes some setup, but it’s quite powerful once implemented.
I’ve actually tackled a similar challenge in my Notion setup. Here’s what worked for me:
For the main project completion, you’ll want to use a rollup property that looks at the subprojects’ completion percentages. Then, create a formula that combines these rollups with your desired weights.
Something like this might work:
(Rollup of Subproject A completion * 0.4) + (Rollup of Subproject B completion * 0.6)
For the subprojects, you can use a formula that counts completed tasks divided by total tasks, multiplied by 100 for a percentage.
It took some trial and error, but once I got it working, it made project tracking much smoother. Just remember to adjust the weights in the main project formula if you add more subprojects later.