💡 How to track Completed On dates on Notion tasks

/ Advice

Nick Gracilla put together some excellent details on how to track Completed On dates when using Notion as a task manager: https://www.nickgracilla.com/posts/automatically-datestamp-completed-tasks-in-notion/

However, it appears Notion has changed slightly since his post was written. Following the instructions in his post word-for-word will lead to an error when you try to insert the formula. To address this situation, I’ve put together a quick set of instructions to begin tracking Completed On dates on Notion tasks:

Required Steps

  1. Make sure you have a ‘Checkbox’ property titled “Done” in your database.
  2. Add the ‘Last edited time’ property to your database and keep it titled as that.
  3. Add a ‘Date’ property to your database and title it “Completed Override”.
  4. Add a ‘Formula’ property to your database and title it “Completed”.
  5. Edit the formula and insert:
prop("Done") ? if(empty(prop("Completed Override")), prop("Last edited time"), prop("Completed Override")) : fromTimestamp(toNumber(""))

Of course, be sure to read Nick Gracilla’s post to understand how this setup works. I’m merely posting about the solution to get it working.

Nick was super nice when I reached out to him on Mastodon and very quick to help me out! Wish I could buy him a beer.

Scroll to Top