Entries

Progress

if(empty(prop("Date Range")), toNumber(""), if(dateBetween(now(), start(prop("Date Range")), "days") / dateBetween(end(prop("Date Range")), start(prop("Date Range")), "days") <= 1, round(dateBetween(now(), start(prop("Date Range")), "days") / dateBetween(end(prop("Date Range")), start(prop("Date Range")), "days") * 1000) / 1000, 1))

Priority

if(prop("Total Priority") == 0, "", if(prop("Total Priority") <= 1, "🚨🚨🚨🚨🚨", if(prop("Total Priority") <= 3, "🔥🔥🔥🔥", if(prop("Total Priority") <= 5, "⭐⭐⭐", if(prop("Total Priority") <= 7, "☕☕", if(prop("Total Priority") <= 8, "☕☕", "😴"))))))

Progress Priority

if(empty(prop("Progress")), toNumber(""), if(prop("Progress") > 0.7, 3, if(prop("Progress") > 0.3, 2, 1)))

Effort Priority

if(empty(prop("Effort")), toNumber(""), if(prop("Effort") == "Low", 1, if(prop("Effort") == "Medium", 2, 3)))

Impact Priority

if(empty(prop("Impact")), toNumber(""), if(prop("Impact") == "Low", 3, if(prop("Impact") == "Medium", 2, 1)))

Total Priority

prop("Progress Priority") + prop("Effort Priority") + prop("Impact Priority")

<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" width="40px" /> By BenLatest • Was this helpful? Please consider buying me a coffee. Cheers!

</aside>