COUNTIFS for assigned to CONTAINING a name


I'm trying to total the numbers of active assignments assigned to a person in a cell that can have muliple selections. .... it's not giving me an error but coming back as 0

=COUNTIFS( [Assigned To]:[Assigned To], CONTAINS("name", @cell), Status:Status, <>"completed")

Anyone help!?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!