Welcome to the New Smartsheet Online Community
You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.
Using COUNTIFS with CONTAINS
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?