Notion Templates
Notion Templates/
All Templates
All Templates/
⚡
Recurring Weekday Tasks
⚡

Recurring Weekday Tasks

Master Tag
Productivity
Created
Jul 23, 2020 01:10 PM
How It Works
https://www.redgregory.com/notion/2020/7/27/planning-with-notion-display-recurring-weekday-tasks
Usage
Web Tags
Database
Planning
Formula
Alternatives
Cover
Video Tutorial
Video preview
💡
Maintenance → Every Week (Sunday) 1. Erase "Ahead" or “Complete” Checkboxes
Recurring Tasks
To Do
Name
Day
Repeat
Last Published
Ahead
Roam
Monday
Thursday
Sunday
Weekly
Jul 19, 2020
Ahead
Notion Essay
Tuesday
Sunday
Monthly
Jun 26, 2020
Ahead
Anki
Wednesday
E.O Week
Jul 19, 2020
Ahead
 
Direction
*Note don't do 1 "weeks" same with "months"
Problem A
contains(prop("Day"), formatDate(now(), "dddd"))
Problem 0
prop("Repeat") == "Weekly" and contains(prop("Day"), formatDate(now(), "dddd")) or prop("Repeat") == "E.O Week" and contains(prop("Day"), formatDate(now(), "dddd")) and dateBetween(now(), prop("Last Published"), "days") > 7
Problem 1 (Monthly)
prop("Repeat") == "Monthly" and contains(prop("Day"), formatDate(now(), "dddd")) and dateBetween(now(), prop("Last Published"), "days") > 29 or prop("Repeat") == "Weekly" and contains(prop("Day"), formatDate(now(), "dddd")) or prop("Repeat") == "E.O Week" and contains(prop("Day"), formatDate(now(), "dddd")) and dateBetween(now(), prop("Last Published"), "days") > 7
Problem 2 (Ahead)
prop("Ahead") ? false : (prop("Repeat") == "Monthly" and contains(prop("Day"), formatDate(now(), "dddd")) and dateBetween(now(), prop("Last Published"), "days") > 29 or prop("Repeat") == "Weekly" and contains(prop("Day"), formatDate(now(), "dddd")) or prop("Repeat") == "E.O Week" and contains(prop("Day"), formatDate(now(), "dddd")) and dateBetween(now(), prop("Last Published"), "days") > 7)
Problem 3 (Last Published Empty)
prop("Ahead") ? false : (empty(prop("Last Published")) and contains(formatDate(now(), "dddd"), prop("Day")) or (prop("Repeat") == "Monthly" and contains(prop("Day"), formatDate(now(), "dddd")) and dateBetween(now(), prop("Last Published"), "days") > 29 or prop("Repeat") == "Weekly" and contains(prop("Day"), formatDate(now(), "dddd")) or prop("Repeat") == "E.O Week" and contains(prop("Day"), formatDate(now(), "dddd")) and dateBetween(now(), prop("Last Published"), "days") > 7))
Problem 4 (Published Today)
(contains(formatDate(prop("Last Published"), "MMM DD, YYYY"), formatDate(now(), "MMM DD, YYYY")) or prop("Ahead")) ? false : (empty(prop("Last Published")) and contains(prop("Day"), formatDate(now(), "dddd")) or (prop("Repeat") == "Monthly" and contains(prop("Day"), formatDate(now(), "dddd")) and dateBetween(now(), prop("Last Published"), "days") > 29 or prop("Repeat") == "Weekly" and contains(prop("Day"), formatDate(now(), "dddd")) or prop("Repeat") == "E.O Week" and contains(prop("Day"), formatDate(now(), "dddd")) and dateBetween(now(), prop("Last Published"), "days") > 7))
 
Simple Alternative
To Do
Name
Day
Complete
Roam
Monday
Thursday
Sunday
Complete
Notion Essay
Tuesday
Sunday
Complete
Anki
Wednesday
Complete
Simple Formula
contains(prop("Day"), formatDate(now(), "dddd")) and empty(prop("Complete"))