Using COUNTIFS when two different ranges

I need a count of items with program = "VRN - Website" but do not count the ones with status = DONE OR NEW

=COUNTIFS({Programs}, "VRN - Website", NOT [{Status}, "Done" OR "New"])

What am I doing incorrect?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!