COUNTIFS CONTAINS problems

Hello,

I am trying to create a formula that will count the cells across spreadsheets using COUNTIFS and CONTAINS. My formula works, however I don't believe it is accurate since I am getting a count of 0 for every scenario I try and apply.

I would like to count the "Requested Delivery Quarter", shown in screenshot two. By matching the "Quarter" and year numbers of the "Start Month"

In my formula I thought I had accounted for all of this, but it seems I am doing something wrong. Is somebody able to help out here?

Here is my formula.

=COUNTIFS({Requested Delivery Quarter}, CONTAINS(Quarter@row, {Requested Delivery Quarter}), {Requested Delivery Quarter}, CONTAINS(RIGHT([Start Month]@row, 2), {Requested Delivery Quarter}))

Thank you!

Screen Shot 2021-10-01 at 9.27.42 PM.png

Screen Shot 2021-10-01 at 9.27.51 PM.png

Find more posts tagged with

Formulas

Accepted answers

All comments

Sean Morgan

Hey there @RingJake

I can see that you have already spoken with our Support Team around this, and were provided a Formula to fit your solution.

If there are any issues, please feel free to respond to the Support Agents Email.

Regards

Sean

RingJake

Hi @Sean Morgan ,

I did speak with the support team but not for this formula. The formula I spoke about previously was the "Creation Date Count".

This one is a bit different because if factors in combining the date year and quarters.

Heather Duff

Hi @RingJake

Have you tried using the COUNT(COLLECT function? https://help.smartsheet.com/function/collect

I have found that it seems to work better than COUNTIFS.

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.