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.

Find more posts tagged with

Accepted answers

Cory Page

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:

All comments

Robert Kubash

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

kira11

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

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

That worked,

Thank you Kira You Rock!!

Robert Kubash

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

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

Yes it seems the formula boxes are tempermental

Cory Page

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.