How to calculate total points for completed tasks in Notion using a formula?

Other Questions Notion
1

Hey everyone! I’m trying to figure out how to add up the points for my tasks using Notion formulas. Here’s what I’m looking to do:

  1. I have a chart with various tasks
  2. Each task carries a specific point value and a current status
  3. I only want to sum the points for tasks that are marked as “done”

Could anyone help me create a formula that checks each task’s status and then totals up the points accordingly? I’m not very skilled with formulas, so any guidance would be greatly appreciated! Thanks a lot!

2

hey laura! i’ve got a simple solution for u. try this formula:

sum(toNumber(prop(“Points”)) * if(prop(“Status”) == “Done”, 1, 0))

it multiplies points by 1 for done tasks and 0 for others, then adds em up. lemme know if it works for ya!

3

I’ve tackled a similar challenge in Notion before. Here’s a formula that should work for your needs:

sum(if(prop(“Status”) == “Done”, prop(“Points”), 0))

This formula checks each task’s status. If it’s “Done”, it adds the points; otherwise, it adds 0. Make sure your status column is called “Status” and your points column is called “Points”. If they have different names, just replace those in the formula.

You can add this formula to a new column in your task database. It’ll automatically update as you mark tasks complete. Hope this helps streamline your point tracking!

4

I’ve been using Notion for task management for quite a while now, and I’ve found a neat trick for calculating points. Instead of using a complex formula, I recommend creating a rollup property. Here’s how:

  1. Make a related database for your points (if you haven’t already).
  2. In your tasks database, create a relation to the points database.
  3. Add a rollup property that sums the points from the related database.
  4. Set a filter on the rollup to only include tasks marked as ‘Done’.

This approach is more flexible and easier to maintain in the long run. Plus, it allows you to easily change point values or add new point categories without messing with formulas. It’s been a game-changer for my productivity tracking!