So I'm trying to create a formula that sorts tasks into a priority list. I want it to sort based on 2 conditions that determine where on the priority list it should be: How many days til it's due and depending on what type of edit I'll need (This will be for an editing job). What I have right now is:
if(prop("Type") == "Short" & (prop("Due Date Priority") < 4, "Urgent", if(prop("Type") == "Medium" & (prop("Due Date Priority") > 10, "Not Urgent", "Middle", )
Due date priority is the amount of days until the due date. I'm not sure if the "&" is even right symbol for it, but hopefully someone can understand this.