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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!