Formula to add check to checkbox based on several other checkboxes

Hi all,

I am trying to create a formula that adds a check to a checkbox once a check has been added to 5 other checkbox fields in the same row. The other checkboxes are also automated and are checked based on other criteria (however, I don't think that matters here). Below is what I have so far, basically if ALL of these fields are checked I want a check, if ANY of the 5 checkboxes are not checked, I want it left unchecked:

=IF([Tech Complete]@row, "Complete", AND([Finance Complete]@row, "Complete", AND([Ops Complete]@row, "Complete", AND([QA Complete]@row "Complete" , AND([Training Complete]@row, "Complete", 1, 0)))))

Any help is appreciated!

Thanks,

Andrea

Find more posts tagged with

Formulas

Accepted answers

Andrea Mayer

As an update, a colleague of mine was able to help me get the right formula. The updated formula is below.

=IF(AND([Comms Complete]@row = "Ready", [Finance Complete]@row = "Ready", [Ops Complete]@row = "Ready", [QA Complete]@row = "Ready", [Training Complete]@row = "ready"), 1, 0)

Thanks!

All comments

Melitta King

Hi,

At a quick glance, there is a comma missing from the formula. After row and before "Complete".

=IF([Tech Complete]@row, "Complete", AND([Finance Complete]@row, "Complete", AND([Ops Complete]@row, "Complete", AND([QA Complete]@row (MISSING COMMA) "Complete" , AND([Training Complete]@row, "Complete", 1, 0)))))

Hope this helps,

Melitta

Andrea Mayer

Thanks Melitta - When I add the comma my error message changes. Previously, it was 'UNPARSEABLE' and now it is 'INVALID DATA TYPE'. Thoughts?

Andrea Mayer

As an update, a colleague of mine was able to help me get the right formula. The updated formula is below.

=IF(AND([Comms Complete]@row = "Ready", [Finance Complete]@row = "Ready", [Ops Complete]@row = "Ready", [QA Complete]@row = "Ready", [Training Complete]@row = "ready"), 1, 0)

Thanks!

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.