<aside> ✅ Hit the Copy button in the upper-right corner of this code block. The formula can then be pasted in a Formula property.
</aside>
if(empty(prop("Parent Task")), "", "➞") + if(prop("Done") == true, "😀", if(empty(prop("Due")), "⚪️", if(formatDate(prop("Due"), "L") == formatDate(now(), "L"), "🟢", if(prop("Due") < now(), "🔴", "🔵"))))
<aside> ✅ This expanded version of the formula is just for reference and learning.
</aside>
if(
empty(
prop(
"Parent Task"
)
),
"",
"➞"
) +
if(
prop(
"Done"
) =
= true,
"😀",
if(
empty(
prop(
"Due"
)
),
"⚪️",
if(
formatDate(
prop(
"Due"
),
"L"
) =
=
formatDate(
now(
),
"L"
),
"🟢",
if(
prop(
"Due"
) <
now(
),
"🔴",
"🔵"
)
)
)
)