COUNTIFS with Not statement

I am encountering an error when trying to use a not statement in a countifs function when referencing different pages.


sudocode: From data on an external sheet provide the count for the following: Count the row if the health is green, and the project is not closed.


This is not compiling.

=COUNTIFS({PMO - Active Project List health}, "Green", NOT({PMO - Active Project List Status1}, "Closed"))

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!