Formula Not work for only 5 months

Hey All,

=COUNTIFS({Request - Create Date}, IFERROR(MONTH(@cell), 0) = [WSSM#]@row, {Request - Create Date}, IFERROR(YEAR(@cell), 0) = Year@row, {Request - Segment}, ="WellMed", {WSS}, ="Accounts Receivable" + COUNTIFS({Complete Create Date}, IFERROR(MONTH(@cell), 0) = [WSSM#]@row, {Complete Create Date}, IFERROR(YEAR(@cell), 0) = Year@row, {Completed Segment}, ="WellMed", {Completed - WSS}, ="Accounts Receivable"))

I'm working on creating a formula that will look at the Month and Year and then count how many instances the WellMed Segment is in a field and the Sub-Segment is accounts recievable.

Basically one sheet is opened and one sheet is completed. For some reason this formula is only not working on Feb-June. Any guesses?

I know the year column isn't in this view but it say 2023 for all 12 Months.

Thanks!

Find more posts tagged with

Accepted answers

Carson Penticuff

It helps me to break out the formula:

You do not need the "=" in {Request - Segment}, ="WellMed",

I'm not sure what you are trying to do with attempting to add "Accounts Receivable" to the result of a nested COUNTIF at the end. Is this a mistake?

Dakota Haeffner

@Carson Penticuff

=COUNTIFS({Request - Create Date}, IFERROR(MONTH(@cell), 0) = [WSSM#]@row, {Request - Create Date}, IFERROR(YEAR(@cell), 0) = Year@row, {Request - Segment}, "WellMed", {WSS}, "Accounts Receivable") + COUNTIFS({Complete Create Date}, IFERROR(MONTH(@cell), 0) = [WSSM#]@row, {Complete Create Date}, IFERROR(YEAR(@cell), 0) = Year@row, {Completed Segment}, "WellMed", {Completed - WSS}, "Accounts Receivable")

All Fixed! :)

Thanks!

All comments

Carson Penticuff

It helps me to break out the formula:

You do not need the "=" in {Request - Segment}, ="WellMed",

I'm not sure what you are trying to do with attempting to add "Accounts Receivable" to the result of a nested COUNTIF at the end. Is this a mistake?

Dakota Haeffner

@Carson Penticuff

All Fixed! :)

Thanks!

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.