Count Formula for more than one condition

PMOGal ✭✭✭✭✭
edited 12/08/23 in Formulas and Functions

Hi. I need to complete this formula:

=COUNTIF([Team Member]:[Team Member], "Joe") and Status <> "Complete" or "Not in Scope".

What is the recommendation to determine how many outstanding tasks Joe has? Thank you.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!