Use Countif to count the number of tasks assigned to a worker?

Valencia C.
Valencia C. ✭✭
edited 12/09/19 in Formulas and Functions

Hi, I'm sure there is a quite dimple solution to the this, but I am having trouble.

I want to count the number of rows assigned to each contact, and I used the formula below:

=COUNTIF(Assigned Work:Assigned Worker, "contactname")

The formula returns the error #UNPARSEBALE

How can I fix this?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!