Forumula Count If

Options

I need to formula to show number of cases assigned to a person but want to exclude any status that is complete. Currently I have =COUNTIF({Collection Legal Log Range 2}, "Agnes Greenhill"), just not sure how to exclude anything in the count that has a complete status. Any suggestions?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!