Master Calendar Tutorial

Master Calendar Tutorial

Master Tag
Productivity
Created
Apr 30, 2022 02:25 PM
Usage
Web Tags
Formula
Dashboard
Database
How To
Alternatives
Cover
notion image

Formulas
dateAdd(dateAdd(dateAdd(dateSubtract(dateSubtract(dateSubtract(dateSubtract(dateSubtract(now(), year(now()), "years"), month(now()), "months"), date(now()) - 1, "days"), hour(now()), "hours"), minute(now()), "minutes"), toNumber(slice(prop("Name"), 6, 10)), "years"), toNumber(slice(prop("Name"), 0, 2)) - 1, "months"), toNumber(slice(prop("Name"), 3, 5)) - 1, "days")
Learn more:
Β 
if(not empty(prop("Notes Added")), "πŸ“ " + format(length(replaceAll(prop("Notes Added"), "[^,]", "")) + 1) + " Notes Added", "")
Β 
if(prop("Tasks Incomplete") > 0, "⭕️ " + format(prop("Tasks Incomplete")) + " Tasks Incomplete", if(not empty(prop("Tasks Allotted")), "βœ… " + format(length(replaceAll(prop("Tasks Allotted"), "[^,]", "")) + 1) + " Tasks Completed", ""))
Β 
prop("Status") == "Completed"
Β 

πŸ“…
Master Calendar
πŸ”
The Activity Log
πŸ“”
Import Apr 19, 2020
🎯
Task List
Β