How can I set different completion percentages for subprojects in Notion?

Other Questions Notion
1

I’m trying to figure out how to manage project completion in Notion. I’ve got a main project with two subprojects, and I’ve added a Completion column. Each subproject has one task marked as Done, but the main project’s completion is showing up empty. I’d like it to show 100% complete.

Also, is there a way to give different weights to the subprojects? For example, could I make Subproject 1 count for 40% of the total and Subproject 2 count for 60%?

I tried messing around with a Formula column, but I couldn’t figure it out. The Notion docs weren’t much help either. Any ideas on how to set this up?

Here’s a quick example of what I’m working with:

Project: Main Project (Completion: ?)
  - Subproject 1 (Completion: 100%)
    - Task 1 (Status: Done)
  - Subproject 2 (Completion: 100%)
    - Task 1 (Status: Done)

Thanks for any help you can offer!

2

hey dancingfox, i’ve got a trick for ya. instead of using formulas, try the ‘Progress’ property type. it lets u set custom milestones for each subproject. then make a rollup in the main project to grab those progresses. u can even add weights by tweaking the rollup formula. it’s way easier than messing with complex formulas trust me

3

Hey there, I’ve been using Notion for project management for a while now and I think I can help you out with this.

For the main project completion, you’re on the right track with the Formula column. What you need to do is create a rollup property that pulls in the completion percentages from your subprojects. Then, in your Formula column, you can average these values to get your overall completion.

As for the weighted percentages, it’s a bit more complex but definitely doable. You could add a ‘Weight’ property to each subproject, then use a formula in the main project that multiplies each subproject’s completion by its weight before summing them up.

Something like this might work:

(toNumber(prop(“Subproject 1.Completion”)) * 0.4) + (toNumber(prop(“Subproject 2.Completion”)) * 0.6)

This assumes Subproject 1 is weighted at 40% and Subproject 2 at 60%. You’ll need to adjust based on your specific needs.

It might take some tweaking to get it just right, but once you’ve got it set up, it should work smoothly. Let me know if you need any more help!

4

I’ve tackled a similar challenge in Notion before. For the main project completion, you’ll need to use a rollup property combined with a formula. First, create a rollup property that collects the completion percentages from subprojects. Then, use a formula to average these values.

As for weighted percentages, it’s trickier but doable. You could add a ‘Weight’ property to each subproject, then use a more complex formula in the main project that multiplies each subproject’s completion by its weight before summing.

Here’s a simplified version of the formula you might use:

(prop(“Subproject 1”) * 0.4) + (prop(“Subproject 2”) * 0.6)

This assumes Subproject 1 is weighted at 40% and Subproject 2 at 60%. Adjust as needed for your specific case. It takes some trial and error, but once set up, it works seamlessly.