Count Children Specific Year

KasandraC

Hi! I keep receiving the "unparsable" error when trying to Count from Children (sub rows) for a specific year.

Current formula entering is =COUNT(CHILDREN([Alliance Partner(s)]@row), ([AM/PM Years Active]@row, = 2024))

Note: AM/PM Years Active column is a multi-select for the years active for those rows/subrows.

Any advice is appreciated.

Find more posts tagged with

Formulas

Countif

Accepted answers

Paul Newcome

You would need a COUNTIFS more like:

=COUNTIFS(CHILDREN([AM/PM Years Active]@row), HAS(@cell, "2024"))

All comments

Paul Newcome

You would need a COUNTIFS more like:

=COUNTIFS(CHILDREN([AM/PM Years Active]@row), HAS(@cell, "2024"))

KasandraC

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