I have tried integrating an Eisenhower matrix into my task list. I have defined urgency with the following formula:
if(dateBetween(now(), prop("Due Date"), "days") < 7, "Urgent", "Not Urgent")
I have another formula that creates a checkbox if the task status is changed to "Done" with the following formula:
equal(prop("Task Status"), "Done")
I want to add a condition to the urgency formula that would leave the cell empty if the task was completed, but I am having trouble writing the correct formula. If someone could help me with writing the correct formula that would be a great help!