I keep getting the error code that there are too many arguments for this function

Copper Contributor

=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"))))))))

1 Reply

@Jeremiah0028 

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