🚀 Next task due in line (displayed in related projects database)

Type

Relations

Next task due in line


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)
	)

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):