Formulas
Date in The Activity Log
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:
Β
Notes Card in The Activity Log
if(not empty(prop("Notes Added")), "π " + format(length(replaceAll(prop("Notes Added"), "[^,]", "")) + 1) + " Notes Added", "")
Β
Task Card in The Activity Log
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", ""))
Β
Done in Task List
prop("Status") == "Completed"
Β
Master CalendarThe Activity LogImport Apr 19, 2020Task List
Β