Need Help - Formula to count status by assigned resource



I need help with COUNTIF syntax. i want to count the nunmber of tasks by status for each of my resources. For example, if I have a resource named Kerry assigned to 100 tasks, how many of Kerry's tasks are Not Started, In-Process, Complete, Past The Planned Start Date and Past the Planned Completion Date.

Many thanks for your help - Kerry


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!