Trying to get a box to check

Good Day,

I am trying to get a box in a column to check if two conditions are met:

  1. If one cell is not blank and the other is blank. I can't get it to work.

=IF(AND(NOT(ISBLANK([Captain Jack's]@row, ISBLANK([Quantity (Captain Jack's)]@row), 0, 1), 0))

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!