# I am trying to get a box to check when specific conditions are met.

Hello,

I am trying to get a box in a cell to check (True) when three or more conditions are met. The conditions to be met are a box checked in the same row. ie if box 1 and box 2 and box 3 are checked (True) them check the box (True)

Here is what I have started it keep showing as invalid or unparseable

=IF(AND(Explorer@row = "true", Practitioner@row = "true", Professional@row = "true") > 0, 1, 0

Any help is greatly appreciated.

• ✭✭✭✭✭

I am sure there is a few ways but I never cared much for using and unless I had to, here is a pretty simple if statement with a count that should work as well if you want a different option.

=IF(COUNTIF(Explorer@row:Professional@row, 1) = 3, 1, 0)

Unchecked one:

• I should also mention that the cells are built as check boxes

• ✭✭✭
edited 07/11/24

Hi!

If you want the final checked only if all three are checked, try this:

=IF(AND(Explorer@row = 1, Practitioner@row = 1, Professional@row = 1), 1, 0)

For formulas with checkboxes they use 1 for true (checked) and 0 for false (unchecked).

• ✭✭✭✭✭

I am sure there is a few ways but I never cared much for using and unless I had to, here is a pretty simple if statement with a count that should work as well if you want a different option.

=IF(COUNTIF(Explorer@row:Professional@row, 1) = 3, 1, 0)

Unchecked one:

• That worked,

Thank you Kira You Rock!!

• Cory and Kira, I want to apply this formula to the whole column but I do not have the option "convert to column formula"

I am not sure why it is not showing

• ✭✭✭✭✭

I accidentally clicked on the check box when trying to open up the formula which erased the formula. Maybe you did the same thing, so long as the formula is in there I am able to convert it over to column.

• Yes it seems the formula boxes are tempermental

• ✭✭✭✭✭

Once you get that converted to a column that temperament goes away it seems.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!