I set up a completion tracker in Notion for a main project with two subprojects, but the progress remains blank. Can I weight them uniquely (e.g., 40% vs 60%)?
hey, try a custom formular that multiplies each subproject’s completion by its respective weight then sums them. might need some tweaking based on your setup, but it worked for me.
In my experience, the solution was to use a combination of numeric properties for each subproject and a formula that assigns a weighted value to each one before summing them up. I had to convert the progress into a decimal figure, multiply it by its respective weight, and then add these values to get a percentage for the overall project. This approach allowed me to visually reflect the differing priorities of each subproject and adjust the weights as needed over time.
In my experience, managing weighted progress in Notion requires setting up individual numeric fields for each subproject and then using a formula to multiply these values by the corresponding weights before summing them up. I made sure that my fields were properly formatted as numbers and converted percentage values into decimals as needed, which helped me avoid issues with blank outputs. With this approach, you not only display the overall progress accurately but also adjust the weights intuitively by simply modifying the formula. Experimenting with different setups often leads to the best outcome.