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!
Answers
-
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
-
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.
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!