I've got a project with a status Select property and three properties with dates. I'm trying to get a formula to display a date based on the status. This formula WAS working, but now it's stopped past a certain point (the first portion still works, the rest displays nothing instead of the two remaining dates), and I can't figure out what I've changed that has made it stop working. Here are the status options:
- If the status is Not Started or Outline In Progress, the date displayed should be Outline Due
- If the status is Outline Complete or Rough Draft In Progress, the date displayed should be Rough Draft Due
- Otherwise, the date displayed should be Final Draft Due
Step 1 is working correctly, but as soon as the status is anything different, the formula's not displaying anything.
formatDate(if(or(prop("Status") == " Outline In Progress", prop("Status") == " Not Started"), prop("Outline Due"), if(or(prop("Status") == " Outline Complete", prop("Status") == " Rough Draft In Progress"), prop("Rough Draft Due"), prop("Final Draft Due"))), "MMMM D, YYYY")
What am I missing that's making this not work? Thanks!