How to count a particular response type within a range based on the submission month

Hi! I'm trying to count all responses to a SmartSheet form with the response "Non-Compliant" within the current month. End users will submit new responses each month and I need the formulas to automatically look for the current month of submissions. I've tried a few things, but always get incorrect argument or unpareseable. Here's what I've tried:

=COUNTIFS({Month}, IFERROR(MONTH(@cell), 0) = MONTH(TODAY()), {General}, "Non-Compliant") —> #INCORRECT ARGUMENT

=COUNTIFS({General}, "Non-Compliant", {Submission Month}, IFERROR(MONTH(@cell), 0) = MONTH(TODAY())) —> #INCORRECT ARGUMENT

=COUNTIF({General}, "Non-Compliant"),AND({Submission Month}=Comments1 —> #UNPARESEABLE

In the last attempt, I had a cell in the sheet where I'm producing calculations reading the current month with "=MONTH(TODAY())" - just trying different things. Any help will be greatly appreciated!

Find more posts tagged with

Accepted answers

All comments

bisaacs

Hey @MK Parrott,

For the Month range, is that just a column that has the month number listed? If not, you'll want to create one that just lists the month #, then you should be able to use this formula:

=COUNTIFS({Month}, MONTH(TODAY()), {General}, "Non-Compliant")

Hope this helps!

MK Parrott

Hi @bisaacs, thank you so much! I tried that - created a column formula using =MONTH(Created@row) and am still getting the same error. Am I doing something weird with the month formula?

bisaacs

Hey @MK Parrott,

What's the column type for the Month? Also what's the error you're getting?

MK Parrott

Hi @bisaacs! I have a Created Date column being converted to the month number using =MONTH(Created@row) as a column formula. That formula is in a text/number column, and is working, but when I try the COUNTIFS statement using the text/number column I still get INCORRECT ARGUMENT. Let me know if I can better clarify - I'm a bit new to smartsheet!

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.