What formula can I use to count multiple values in a cell?

I am trying to figure out how to track/count information in a cell with multiple values (multiple people assigned to tasks, and I want to be able to show how many tasks each person is assigned to).

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!