This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I tried to make a custom formula with this expression, but it fails.
If(Or(Phase= “5. On Hold”, StartDate>Today()),
“5. On Hold”,
If(Phase= “Complete”,
“Complete”,
If(Or(Phase= “1. ToDo”,
And(DueDate<=(Today()+7), Phase <>“Complete”, Phase<>“5. On ...
