Hi, Hello! My name is Sarah - the writer behind redgregory.com.
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
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
Roam