Counting number of employees with tasks assigned to them

Options

Hi all,

I was wondering if it's possible to count number of employees with tasks assigned to them?

The Responsible column is a contact list, is this OK when making a formula in the sheet summary section?

I want to be able to do something like:

COUNTIF([Responsible]:[Responsible], MG) Get the total and the further count how many task MG has due in one week or how many tasks he has overdue.

Is this possible?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!