Count open RAID items based off of dropdown menu

I'm trying to get a count of open RAID items. We have the following statuses in the status dropdown: New, In Progress, Backlog, Requires Validation, and Complete.

What is wrong with this formula?:

=COUNTIFS([Type (RAAIDD)]:[Type (RAAIDD)], "Risk", Status:Status, OR(@cell = "New", @cell = "In Progress", @cell = "Requires Validation"))

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

I don't see anything wrong with the formula or the output. Based on the data in the screenshot, you only have one row that fits all of your criteria, more specifically the [Type (RAAIDD)] column having the text of "Risk".

Allison H

Thanks Paul!

Paul Newcome

Happy to help! 👍️

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.