Count when 2 conditions are met

Having an issue getting a count when two conditions are met from two ranges/columns from a different sheet. This is what I have but doesn't work:

=COUNTIFS([{Serviceability Check Requests Range 2}]:[{Serviceability Check Requests Range 2}], “May 2025”, [{Serviceability Check Requests Range 3}]:[{Serviceability Check Requests Range 3}], "Customer Service")

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

There are a number of issues. What does this one give you?

=COUNTIFS({Serviceability Check Requests Range 2}, "May 2025", {Serviceability Check Requests Range 3}, "Customer Service")

jgenove

@Paul Newcome this works perfectly! I appreciate your help!

Paul Newcome

Happy to help. 👍️

Something to keep in mind… While most of the adjustments are pretty clear such as the change to how the cross sheet references were entered, one that may not be immediately noticeable and trips up a lot of users is the quotes. See how the ones in your original post around May 2025 are slanted to show open vs closed but the others are straight up and down? Those are called "smart quotes" which are (ironically enough) not recognized as valid characters in a Smartsheet formula. Retyping them here in the community, directly in Smartsheet, or in a text editor such as Notepad (not Word) will give you the quotes you need.

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.