Project Status

Status

lets(
	dt, prop("Date").formatDate("L"),
	db, prop("Date").dateBetween(now(), "days"),
	ifs(
		dt == now().formatDate("L"), "Due Today", 
		dt == now().dateAdd(1, "days").formatDate("L"), "Due Tomorrow", 
		now() > prop("Date"), "Overdue", 
		db > 2, db + " days left"
	)
)

<aside> ⚠️ The database above uses a formula to calculate the Date property so the example stays current. The Status formula will work as required when using a regular date property.

</aside>

• Old Explanation