Countif formula; exclude completed status



I currently have the formula to count how many priority levels each team has but would like to exclude the completed items from the count. Is there an additional piece of the formula that I need to include?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!