Count Children Specific Year

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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!