Combining "blank" cells with a checkbox - notification

I am trying collectively check the box for "MIssing coating Weights" IF - one column of each coating weight is blank AND the Recheck and/or No Coating Weights Required box is NOT checked.

Thanks!

=IF([Recheck and/or No Coating Weights Required]@row, 1), "", IF(AND([1421 CTG WTS OP]@row = "", [902 CTG WTS OP]@row = "", [1402 CTG WT Top OP]@row = "", [1455 CTG WT Top OP]@row = "", [1430 CTG WT Top OP]@row = "", [Recheck and/or No Coating Weights Required]@row, 0), 1, 0))


Tags:

Answers

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭

    Hi @Elizabeth Aird,

    I think this should do the trick for you:

    =IF([Recheck and/or No Coating Weights Required]@row = 1, 0, IF(AND([1421 CTG WTS OP]@row = "", [902 CTG WTS OP]@row = "", [1455 CTG WT Top OP]@row = "", [1402 CTG Top OP]@row = "", [1430 CFG WT TOP OP]@row = "", [Recheck and/or No Coating Weights Required]@row = 0), 1))

    Sample output:

    A few of these columns are not visible in your screenshot, but the first two appear to have slightly different names to the remaining ones, so if you are still getting an error, you may be able to see this by the colouration of the formula:

    This is OK, while the below is not as the first column of the AND statement doesn't exist:

    Hope this helps, but if you've any problems/questions then just post! 🙂

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!