Help with custom formula

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?

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

1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.