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!



Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!