Using COUNTIFS with OR and CONTAINS
Hi All,
I'm trying to create a formula to count how many requests of a specific type my team handled on a given week. I have the table set up like this:
in the column of insights decks, I would like the formula to count how many times a request was put in that week, that has either Insights, Screenshots, or Campaign in the names (The original names are Standard Insights Requests, Quick Screenshots (no write up), Post Demo Screenshots, Quick Screenshots (Include write up), Post Campaign Report. I'm doing Contains instead of just OR with the exact text since the options that have parentheses in the names messed up the formula).
Here's what I've got based on some threads I found here:
=COUNTIFS({Request Format}, OR(CONTAINS("Insights", @cell), CONTAINS("Screenshots", @cell), CONTAINS("Campaign", @cell)), {Calender Week}, [Column2]@row).
Unfortunately, it brings back zero as can be seen in the screenshot above, even though I have the numbers it should bring back and it's definitely not zero. Any idea what I'm doing wrong here?
Thank you!
Best Answer

Thank you Jeff! I think I figured it out, the dates were 2022 instead of 2021 :) Once I changed that it worked perfectly.
Answers

You may need an operator for the {Calendar Week} criteria:
=COUNTIFS({Request Format}, OR(CONTAINS("Insights", @cell), CONTAINS("Screenshots", @cell), CONTAINS("Campaign", @cell)), {Calender Week}, =[Column2]@row)
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Thank you Jeff! I think I figured it out, the dates were 2022 instead of 2021 :) Once I changed that it worked perfectly.
Help Article Resources
Categories
Check out the Formula Handbook template!