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

Robert Kubash · 07/11/24

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.

Cory Page · 07/11/24

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:

Robert Kubash · 07/11/24

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

kira11 · 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).

Cory Page · 07/11/24

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:

Robert Kubash · 07/11/24

That worked,

Thank you Kira You Rock!!

Robert Kubash · 07/11/24

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

Cory Page · 07/11/24

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.

Robert Kubash · 07/11/24

Yes it seems the formula boxes are tempermental

Cory Page · 07/11/24

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

Formulas and Functions

Formulas and Functions

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

Best Answer

Answers

Help Article Resources

Quick Links

Categories

Trending in Formulas and Functions

Formula - use % complete to determine whether in progress

Formula error

TRYING TO FIND THE ERROR IN THIS FORMULA