Counting Monthly Intakes per Segment

Hi all I am trying to figure out why my formula isn't running correctly. I want to count how many times a specific segment put in a request per month. For Example if the nurse team made 10 request in January and 12 in February. I have about 10 other segments to fit in. I also only need to count Parent rows which are identified as "TOP".

I am counting the total completed work and current intakes hence the "+".

=COUNTIFS({Completed - Create Date}, IFERROR(MONTH(@cell), 0) = MONTH(1), {Completed - Create Date}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()), {Completed - Parent ID}, ="TOP", {Request - Segment}, ="Nurse") + COUNTIFS({Request - Create Date}, IFERROR(MONTH(@cell), 0) = MONTH(1), {Request - Create Date}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()), {Request - Parent ID}, ="TOP", {Request - Segment}, ="Nurse")

I feel like the problem is with the Month(1) section but I'm not certain.

Thanks!

Find more posts tagged with

Formulas

Accepted answers

David Tutwiler

You should be able to replace MONTH(1) with 1. The MONTH formula will simply return the number of the month in the associated date (1-12). There is no need to wrap the month number in the MONTH formula again.

All comments

David Tutwiler

Dakota Haeffner

Thank you for teaching me how to use that correctly @David Tutwiler!

I knew it had to be something silly.

David Tutwiler

No problem. Glad it's working for you.

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.