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

• ✭✭✭✭✭✭

Try this: =IF(AND(NOT(ISBLANK([Captain Jack's]@row)), ISBLANK([Quantity (Captain Jack's)]@row)), 1, "")

Best of luck to you!

BRgds,

-Ray

It worked!!! Thank you so very much @Ray Lindstrom

• ✭✭✭✭✭✭

Try this: =IF(AND(NOT(ISBLANK([Captain Jack's]@row)), ISBLANK([Quantity (Captain Jack's)]@row)), 1, "")

Best of luck to you!

BRgds,

-Ray

• ✭✭✭

I am search of the same type of help. Should the formula contain an COUNTIFS?

It worked!!! Thank you so very much @Ray Lindstrom

• ✭✭✭✭✭✭

@LMC,

No countifs for this particular situation.

• @Ray Lindstrom Thanks again. I am now trying to get the box to check dependent on two separate scenarios. The one you helped me with above plus another.

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

I tried all different ways but still not working. Do you see anything right away that is wrong?

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!