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

ktpreusser · 01/14/25

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!

Paul Newcome · 01/14/25

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 · 01/14/25

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 · 01/14/25

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

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

.

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

Answers

Help Article Resources

Categories