How to create an If Formula for working with Dates | Notion

Notion Jul 30, 2021

Let's create a formula for working with dates and then make that shit bop.

You can create a formula so only the date with the selected status is appearing in the calendar.

A little bit of something that you might expect

Suppose that you are a content creator and want to schedule dates in your calendar so you separate them by the names - 'Plan', 'shooting', and 'editing'.

if(prop("Status") == "Plan", prop("Plan"), if(prop("Status") == "Shooting", prop("Shooting"), if(prop("Status") == "Editing", prop("Editing"), now())))
Suppose you use a plan like this

The problem that you'll face with a code like this is that if you add no status it will show the now() date and most of the items won't have a status.

So, if you would like to keep it empty and don't want it to appear on the calendar, keep on reading ;)

Step 1:

Create a new column duplicating Plan, Shooting or Editing.

Step 2:

Rename it to "Nothing".

Step 3:

Right click and hide that column.

Step 4:

Add an extra line to your formula:

if(prop("Status") == "", prop("Nothing")

Step 5:

In the calendar view add a Filter "Where > Status - Is not empty"

When you have followed all of these steps correctly, you'll be able to design a formula so only the date with the selected status is appearing in the calendar.

Learning Notion formulas is sweet, but using templates that has inbuilt formulas is sweeter! Check out Notion templates from our wide range of free and premium templates here

I'm happy - happy - happy ;D


Priya Srivastava

Photoshop Artist 🧙‍♂ī¸ | Coding = The butter to my bread 🍞 | Fitness junkie 🧗‍♂ī¸â›šī¸â€â™€ī¸ | Gamer 🚀 | writer ✏| A proud memer 💟| Notion-er 💌

Great! You've successfully subscribed.
Great! Next, complete checkout for full access.
Welcome back! You've successfully signed in.
Success! Your account is fully activated, you now have access to all content.