COUNTIFS CONTAINS plus DATE

Hi there,

I am building out a quality control function. I have a list of findings that I would like to tally each month. So I would like, for the month of February, for my tally sheet to count the total number of items with "Analysis Needs Enhancement (Critical)" (for example) that is between the dates of February 1, 2024 and February 29, 2024.

I feel like I'm on the right track but... not there.

=COUNTIFS({Complete-CriticalErrors}, CONTAINS("Analysis Needs Enhancement (Critical)"), AND({DateItemCompleted}@cell, >= DATE(2024, 02, 01), {DateItemCompleted}@cell <= DATE(2024, 02, 28)))

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!