Ben SmithBen Smith
Ben Smith/
Priority Level
Priority Level
Priority Level

Priority Level

For
jaquarman
From
Reddit
Status
Updating
Formulas
if
if
empty
empty
formatDate
formatDate
==
==
>
>
now
now
Share

Priority Level

if(empty(prop("Date")), "0 - Pending", if(formatDate(now(), "L") == formatDate(prop("Date"), "L"), "3 - High Priority", if(now() > prop("Date"), "4 - ASAP", if(dateBetween(prop("Date"), now(), "days") > 7, "1 - Low Priority", "2 - Medium Priority"))))

Priority Level (Emoji)

if(empty(prop("Date")), "⚪️  0 - Pending", if(formatDate(now(), "L") == formatDate(prop("Date"), "L"), "🟡  3 - High Priority", if(now() > prop("Date"), "🔴  4 - ASAP", if(dateBetween(prop("Date"), now(), "days") > 7, "🔵  1 - Low Priority", "🟢  2 - Medium Priority"))))
Explanation
if(empty(prop("Date")), "0 - Pending",
If Date is empty, display 0 - Pending.
if(formatDate(now(), "L") == formatDate(prop("Date"), "L"), "3 - High Priority",
Otherwise if the current date formatted as MM/DD/YYYY matches the same for Date, display 3 - High Priority.
if(now() > prop("Date"), "4 - ASAP",
Otherwise if the current date is greater than Date, display 4 - ASAP.
if(dateBetween(prop("Date"), now(), "days") > 7, "1 - Low Priority",
Otherwise if the number of days between the current date and Date is greater than 7, display 1 - Low Priority.
"2 - Medium Priority"))))
And if none of the above match, display 2 - Medium Priority.
 
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!