Help with custom formula

[Hans-Christian_]

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 Hold” ) ),
“1. ToDo”,
If(Phase = “2. Planning”,
“2. Planning”,
If(Phase = “3. Doing”,
“3. Doing”,
If(Phase = “4. Controlling”,
“4. Controlling”
))))))

Do you have any advice?

[Databaser]

Hi @Hans-Christian_Franc and welcome to the community!

Hans-Christian_Franc:

And(DueDate<=(Today()+7), Phase <>“Complete”, Phase<>“5. On Hold” ) ),

I think the “+7” part after Today() isn’t possible. If you remove that, does it work?

[Hans-Christian_]

@Databaser - nope, no change

[Hans-Christian_]

Hans-Christian_Franc:

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 Hold” ) ),
“1. ToDo”,
If(Phase = “2. Planning”,
“2. Planning”,
If(Phase = “3. Doing”,
“3. Doing”,
If(Phase = “4. Controlling”,
“4. Controlling”
))))))

Replaced “ with "

If(Or(Phase = “5. On Hold”, StartDate > Today()),
“5. On Hold”,
If(Phase = “Complete”,
“Complete”,
If(Or(Phase = “1. ToDo”,
And(DueDate <= Today(), Phase <> “Complete”, Phase <> “5. On Hold” ) ),
“1. ToDo”,
If(Phase = “2. Planning”,
“2. Planning”,
If(Phase = “3. Doing”,
“3. Doing”,
If(Phase = “4. Controlling”,
“4. Controlling”
))))))

…but still does not work.

[Hans-Christian_ · Accepted solution]

Figuered:

IF(OR(Phase = “5. On Hold”, StartDate > TODAY()),
“5. On Hold”,
IF(Phase = “Complete”,
“Complete”,
IF(OR(Phase = “1. ToDo”,
AND(DueDate <= TODAY(), Phase != “Complete”, Phase != “5. On Hold” ) ),
“1. ToDo”,
IF(Phase = “2. Planning”,
“2. Planning”,
IF(Phase = “3. Doing”,
“3. Doing”,
IF(Phase = “4. Controlling”,
“4. Controlling”
))))))