COUNTIFS with OR - Syntax Questions

I have a sheet that has a TARGET DATE and STATUS. I want a count of rows where the STATUS is either WIP or NEW and the DATE < Today. The goal is a count of rows that are overdue. I've been trying different variations of this formula.

=COUNTIFS({TARGET DATE}:{TARGET DATE}, < TODAY(), {STATUS}, or(@CELL = "New", @CELL = "WIP"))

I'm pretty sure it's a syntax issue, but I have not hit on the right combination.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!