Type
Total tasks due this week
"_______________________________" +
"\n" +
"Total tasks due this week: " +
let(
dueThisWeek,
(prop("Tasks").filter(current.prop("Due Date").week()==today().week())),
dueThisWeek.length()
).style("pink,b,u")Output example: The first line below the divider shows the formula's result.
This formula can also be used in your Projects database when related to Tasks database to show the total number of tasks due this week for each project.