Using COUNTIFS with CONTAINS

Hello,

I have a contact column where some rows have more than one person assigned to a task. I want to count the number of tasks assigned to any given individual. This is the formula that I have created to do this:


=COUNTIF(CONTAINS("Bernie Sanders", [Assigned]:[Assigned]), "True")


The return value that I get is "0," which is not correct.

Is there another formula that I can try?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!