COUNTIFS formula troubleshooting - multiple criteria and checkboxes

Hi SmartSheets Community,

I'm new to Smartsheet (but know some basic Excel), but am getting stumped on this formula. Can you advise what I'm doing wrong?

I'm trying to create a formula that 1) counts either Red or Blue cells in another spreadsheet column (Other Sheet Range 1), and then 2) counts a checkmark (or no check mark). When I enter this in, I get #UNPARSEABLE. Any guidance on what I'm doing wrong?

Checkmark formula:

=COUNTIFS({Other Sheet Range 1}, OR(@cell = "Red", @cell = "Blue"), {Other Sheet Range 5}, =1))

No Checkmark formula:

=COUNTIFS({Other Sheet Range 1}, OR(@cell = "Red", @cell = "Blue"), {Other Sheet Range 5}, 0))

Find more posts tagged with

Formulas

Accepted answers

Sameer Karkhanis

Try the below: (You had an extra parenthesis at the end in both the formula and also changed =1 to just 1)

=COUNTIFS({Other Sheet Range 1}, OR(@cell = "Red", @cell = "Blue"), {Other Sheet Range 5}, 1)

=COUNTIFS({Other Sheet Range 1}, OR(@cell = "Red", @cell = "Blue"), {Other Sheet Range 5}, 0)

All comments

Sameer Karkhanis

Try the below: (You had an extra parenthesis at the end in both the formula and also changed =1 to just 1)

=COUNTIFS({Other Sheet Range 1}, OR(@cell = "Red", @cell = "Blue"), {Other Sheet Range 5}, 1)

=COUNTIFS({Other Sheet Range 1}, OR(@cell = "Red", @cell = "Blue"), {Other Sheet Range 5}, 0)

CowboyB

https://community.smartsheet.com/discussion/comment/327487#Comment_327487

Thank you Sameer!! This was driving me crazy, and I couldn't figure it out. Appreciate it!!

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.