✂️

Notion Formula: Start Automating Your Time Table

Created
Jan 12, 2021 12:33 PM
↙️
Hi, Hello! My name is Sarah - the writer behind redgregory.com.
notion image
Get started automating your timetable with this formula. This approach to scheduling is great for making appointments with team members, tracking daily tasks in the morning, and more. If you're familiar with Notion formulas, this can act as a great jumping off point to customize your own table.
🔥
How does the formula work? Condition 1: if tags say time (in 1 hour interval), do task at that time today False Condition: if not, do task at 5pm
if(prop("Time") == "12am", dateSubtract(dateSubtract(now(), hour(dateSubtract(now(), 1, "days")), "hours"), minute(now()), "minutes"), if(contains(prop("Time"), "am"), dateSubtract(dateAdd(now(), toNumber(prop("Time")) - hour(now()), "hours"), minute(now()), "minutes"), if(contains(prop("Time"), "pm"), dateSubtract(dateAdd(now(), toNumber(prop("Time")) + 12 - hour(now()), "hours"), minute(now()), "minutes"), dateSubtract(dateAdd(now(), 17 - hour(now()), "hours"), minute(now()), "minutes"))))
Copy the template →
🕥
Auto Select → Timetable

What You Need

  • A database with a select property called “Time,” and each select will be formatted “#am/pm.” You also need a formula property to plug in the code provided in the template.
    • !OR ... just duplicate the template

How To Use It

  • After applying the formula, select a time from the select property and watch the formula generate a date and time for today @ time selected.
1 Hour Intervals
Name
Time
Convert To Date/Time
Person
Complete
8am
Complete
9am
Complete
2pm
Complete
4pm
Complete
5pm
Complete
8pm
Complete
11pm
Complete
12am
Complete

Done For The Day?

When you're done your tasks for the day, clear your database by clicking on the first column cell and dragging down to delete all entries.

My Mental Model For Stress

My Mood

Highest Performing Tweet

Content Published This Week

Video preview
Roam
Video preview