Question

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:

1. If the status is Not Started or Outline In Progress, the date displayed should be Outline Due
2. If the status is Outline Complete or Rough Draft In Progress, the date displayed should be Rough Draft Due
3. 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!

Answer 1

It looks like there might be some leading whitespace in your Status property comparisons that could be causing the issue.

The extra spaces at the start of the status strings, like " Outline In Progress" and " Not Started", can cause these comparisons to fail because the status value likely does not include this leading whitespace. This might be caused by the emojis there too. Try this and see if it resolves the issue.

I tried this formula without the white spaces and it works fro me. I did not play around with the emojis though.

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")