Hi @Hans-Christian_Franc and welcome to the community!

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

@Databaser - nope, no change

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.

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”

))))))