COUNTIF Formula

Options

How do I add to this formula to only capture 2023Q1, 2023Q2 completed- prioritized projects? I am currently using the formula below, but its capturing all of the completed- prioritized projects from other years.

=COUNTIFS({MH-Work Prioritization Log Range 1}, "Completed- Prioritized")

I also would like a formula to count for 2023Q1, 2023Q2, 2023Q3, and 2023Q4

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!