Status formula with check box criteria

BettyJo

I am attempting to add a check box criteria to a Status Column formula. If the PRODUCTION HOLD box is checked, then it is on "PRODUCTION HOLD", if not then it is "RELEASED FOR PRODUCTION". This criteria needs to go first before the remaining production status criteria in this formula.

Some error I'm making in the bolded portion of this formula is resulting in "INCORRECT ARGUMENT". Without it, formula works fine. What am I doing wrong?

=IF([PRODUCTION HOLD]@row = 1, "PRODUCTION HOLD", "RELEASED FOR PRODCUTION", IF(ISBLANK([2. ACTUAL PRODUCTION DATE]@row), "Not Produced", IF(ISBLANK([CONTECH ACTUAL INSPECTION]@row), "Produced, Pending Contech QC", IF(ISBLANK([SCN #]@row), "QC Approved, Pending SCN", IF(ISBLANK([BOL NUMBER]@row), "SCN Assigned, Pending BOL", IF(ISBLANK([ACTUAL SHIP DATE]@row), "BOL Assigned, Pending Shipping", "Shipped"))))))

ECarlson_PCG

You're adding a close to your nested IF, stopping the formula and creating that error, I'd modify it to:

=IF([PRODUCTION HOLD]@row = 1, "PRODUCTION HOLD", IF([PRODUCTION HOLD]@row = 0, "RELEASED FOR PRODCUTION", IF(ISBLANK([2. ACTUAL PRODUCTION DATE]@row), "Not Produced", IF(ISBLANK([CONTECH ACTUAL INSPECTION]@row), "Produced, Pending Contech QC", IF(ISBLANK([SCN #]@row), "QC Approved, Pending SCN", IF(ISBLANK([BOL NUMBER]@row), "SCN Assigned, Pending BOL", IF(ISBLANK([ACTUAL SHIP DATE]@row), "BOL Assigned, Pending Shipping", "Shipped")))))))

prime_nathaniel

@BettyJo the format is

if(this, then this, otherwise this)

when you nest them it is

if(this, then this, if(this, then this, otherwise this))

you can see from your formula, ou have 3 things before your next if() so you have already filled out the "otherwise this" parameter. There should only be 2 items if you want to do nested ifs.

IF(
[PRODUCTION HOLD]@row = 1,
"PRODUCTION HOLD",
"RELEASED FOR PRODCUTION",
IF(ISBLANK([2. ACTUAL PRODUCTION DATE]@row), "Not Produced", IF(ISBLANK([CONTECH ACTUAL INSPECTION]@row), "Produced, Pending Contech QC", IF(ISBLANK([SCN #]@row), "QC Approved, Pending SCN", IF(ISBLANK([BOL NUMBER]@row), "SCN Assigned, Pending BOL", IF(ISBLANK([ACTUAL SHIP DATE]@row), "BOL Assigned, Pending Shipping", "Shipped")))))
)

ECarlson_PCG

You're adding a close to your nested IF, stopping the formula and creating that error, I'd modify it to:

=IF([PRODUCTION HOLD]@row = 1, "PRODUCTION HOLD", IF([PRODUCTION HOLD]@row = 0, "RELEASED FOR PRODCUTION", IF(ISBLANK([2. ACTUAL PRODUCTION DATE]@row), "Not Produced", IF(ISBLANK([CONTECH ACTUAL INSPECTION]@row), "Produced, Pending Contech QC", IF(ISBLANK([SCN #]@row), "QC Approved, Pending SCN", IF(ISBLANK([BOL NUMBER]@row), "SCN Assigned, Pending BOL", IF(ISBLANK([ACTUAL SHIP DATE]@row), "BOL Assigned, Pending Shipping", "Shipped")))))))

BettyJo

Thank you, this was very helpful and got me what I needed!