Donate
Task List
Not Started
0In Progress
0Completed
0Formula
if(prop("Status") != "Completed", if(prop("Impact") == "Major" and dateBetween(prop("Deadline"), now(), "days") <= 6 and prop("Automate?") == false or formatDate(prop("Deadline"), "L") == formatDate(now(), "L") or prop("Critical?"), "Quadrant 1", if(prop("Impact") == "Minor" and dateBetween(prop("Deadline"), now(), "days") <= 6 or prop("Automate?") == true, "Quadrant 3", if(prop("Impact") == "None" or and(prop("Impact") == "Minor", dateBetween(prop("Deadline"), now(), "days") > 6), "Quadrant 4", if(or(prop("Impact") == "Major", prop("Impact") == "Neutral") or dateBetween(prop("Deadline"), now(), "days") > 6 and prop("For") == "Myself", "Quadrant 2", "")))), "")