Formula to describe # of applicants per department in a specific quarter.

I have a CountIFs formula I have been trying to make work in order to tell me how many applicants we have for a specific department within a quarter.

=COUNTIFS({Quarter}, "Q1 2025", [{Department,[Primary Column]@row])

I am receiving an UNPARSEABLE error. Both range1 and range2 are references to the same separate sheet, but different columns. Both columns are drop down selections. The primary column is the department name.

Any help would be so appreciated!!!! Thanks!

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

The square brackets around the second range/criteria set need to be removed. You are also missing a closing curly bracket after the second {Cross Sheet Reference}.

ktpreusser

https://community.smartsheet.com/discussion/comment/468197#Comment_468197

I fixed this, but now I am getting an Invalid reference error. Any Ideas?

Paul Newcome

That means at least one {Cross Sheet Reference} has not been properly created.

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references

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.