Matrix Formula

Matrix Formula

Master Tag
Productivity
Created
Mar 30, 2022 11:17 AM
How It Works
Usage
Web Tags
Database
Dashboard
Formula
Alternatives
Cover

Donate

 
notion image
Task List
Not Started
0
In Progress
0
Completed
0
Task List
Formula
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", "")))), "")