Syntax for formula with a checkbox

Need help with syntax for a formula for counts.

Goal: Give a count where If STATUS field contains string value "new" and where a checkbox named External is checked.

Formula: =COUNTIFS(Status:Status, "New", [External:External, "True"])

Currently getting an error: #UNPARSEABLE

Find more posts tagged with

Countif

checkbox

Accepted answers

VBAGuru

Try

=COUNTIFS(Status:Status, "New", External:External, 1)

check boxes are 0 or 1 and brackets should not go around the second statement

All comments

VBAGuru

Try

=COUNTIFS(Status:Status, "New", External:External, 1)

check boxes are 0 or 1 and brackets should not go around the second statement

Hasan_M

It worked - Thank You @VBAGuru !!!

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.