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.

Paul Newcome

You would need a COUNTIFS more like:

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

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. 👍️