Boolean Expected

=COUNTIFS({Client Name/Planter Location}, Client@row, {Bed Plants (Early Spring)}, 1)

I'm trying to match a name on a current sheet with that on another sheet; and on the other sheet, the name may appear multiple times with one or more checked boxes under Bed Plants Early spring.

The results are: a box gets checked or i get the boolean expected error. I checked the source sheet: if the Bed Plants early spring has multiple checked boxes, I get a boolean expected; if there is only one box checked, I get a box checked.

How do i just get the box to be checked.

Find more posts tagged with

Countif

Accepted answers

All comments

Sandy Drew

A countifs can result in any number value, so if you're adding this to a checkbox column, it can't understand any value other than 1 and 0. A boolean error means it needs the result to be true or false (1 or 0). I would recommend using the formula below instead.

=IF(AND({Client Name/Planter Location} = Client@row, {Bed Plants (Early Spring)} = 1),1,0)

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.