COUNTIFS CONTAINS problems

RingJake

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!

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.