Jan 22, 2021 02:14 AM
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?
Solved! Go to Solution.
Jan 22, 2021 06:58 AM
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”
))))))
Jan 22, 2021 02:57 AM
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?
Jan 22, 2021 03:06 AM
@Databaser - nope, no change
Jan 22, 2021 04:55 AM
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.
Jan 22, 2021 06:58 AM
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”
))))))