Trying to get OR to work with Countifs

Options

First part of Countifs works, cannot get OR to work.

Want to count everything that is before today that is Current State ="In Queue" or "In Process". Current error I get is invalid operation. Have tried multiple iterations without luck. What am I missing? Thanks!

=COUNTIFS({CNC, CMM, and BL Request Sheet Need by date}, <TODAY(0), OR({CNC, CMM, and BL Request Sheet Current State} = "In Queue", {CNC, CMM, and BL Request Sheet Current State} = "In Process"))

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!