The "Tasks" property is a relational property that you create in a database (for example in "Projects"). Ensure that the status names in your formula exactly match your actual task statuses. The formula will show ⚠️ for overdue tasks and ⏩ for the next upcoming task that isn't overdue.
Example output (shown at the bottom):
lets(nextDue,
(filter(
prop("Tasks"),
current.
prop("Status").contains("Not started")
or
current.
prop("Status").contains("In progress"))
.map(current.
prop("Due Date"))
.sort()
.first()),
nextTask,
(filter(prop("Tasks"),
current.prop("Due Date")== nextDue
&&
(current.prop("Status").contains("Not started")
or
current.prop("Status").contains("In progress"))).first())
,
if (nextDue < today(), "⚠️ ".style("red") + nextDue + " " + nextTask, "⏩ " + nextDue + nextTask)
)