Dashboard formulas - Need to count if a person is included in Owner Column and the task is not close

edited 12/09/19 in Formulas and Functions

Trying to calculate the number of tasks by person that are not closed. I currently have:

=COUNTIFS({Tracker Range 6}, ="Andy", {Tracker Range 2}, <>"CLOSED")

Where the Range 6 is the Owner column and Range 2 is the Status Column (Open, Closed, Hold). 

I am getting responses, but I think it is only counting where the owner is the only entry in the cell...many have shared ownership. How do I indicate where the name is included and not the only entry?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!