In my new goal tracking template (with projects and tasks databases, I may release a free public template soon) I've found the new Status property a welcome addition.
What I'm even more delighted about, is having a completion number to check my progress that takes very little setup, through the new Status property.
Let me show you what I mean and how to set it up.
In this example, I show 4 tasks completed, out of 11 in total that are in Not Started and In Progress status in my Tasks database |
Both of these options are very simple to setup:
- Have a 2-way relation between your Tasks and Projects database and connect your tasks with their project (In my case this was already done)
- Create a rollup that relates to the Task database, and select "status" as the property, then Calculate "Count per group -> Complete"
- If you want to display some text with it, like in my achievements screenshot above, create a "concat" formula like so: concat("you have completed ", prop("completed tasks"), " tasks") where prop("property name here") is the Rollup property of your Completed tasks calculation.
As someone with ADD, visualizing my progress gives me a daily drive to do better and keep going. How about you?
Disclaimer: The content provided in this article is for informational purposes only. You are solely responsible for verifying the information as being appropriate for your personal use.