Sep 24 2024 02:17 PM
=IF([@[Everything added]]="X", "DONE", (IF(AND([@[TCO Ship Date]]<=TODAY()+3, ([@LAT]="X")), "Order PD", "Order Motors", (IF([@[TCO Ship Date]]<=TODAY()+8, "Order Motors", (IF([@[TCO Ship Date]]<=TODAY()+15, "Order DTI Only", "Wait"))))))))
Sep 24 2024 02:49 PM
Yes, too many of them on second IF
=IF( [@[Everything added]]="X",
"DONE",
IF( AND([@[TCO Ship Date]]<=TODAY()+3, [@LAT]="X"),
"Order PD",
"Order Motors", // one of this is to be removed
IF( [@[TCO Ship Date]]<=TODAY()+8,
"Order Motors",
IF([@[TCO Ship Date]]<=TODAY()+15,
"Order DTI Only",
"Wait"))))