Counting number of employees with tasks assigned to them

sedin hasanovic

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?

sedin hasanovic

I tried to do something like: =COUNTIF([Responsible]:[Responsible], AM) but that still does not work coming up as #UNPARSEABLE.

Sameer Karkhanis

If your column is a defined as single contact per cell then you can use,

=COUNTIF([Responsible]:[Responsible], "AM")

If your column can have multiple contact values per cell then use,

=COUNTIF([Responsible]:[Responsible], HAS(@cell, "AM"))

sedin hasanovic

Hey Sameer, it simply just comes up with #invalid column value doing either of those formulas when trying to apply them. Do I have to use the email value?

Andrée Starå

Hi @sedin hasanovic

I hope you're well and safe!

Try something like this.

=COUNTIF(Responsible:Responsible, "AM")

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

sedin hasanovic

I've tried that combination. It looks like there might be something wrong with the sheet, because when I try the formula in another sheet see below:

Could there be a setting or something in the other sheet stopping me from making this formula work?

Andrée Starå

@sedin hasanovic

Strange!

Can you paste the formula you used in the other sheet that works?

sedin hasanovic

@Andrée Starå Hey mate, i think it might be something to do with the limitation Smartsheet has. I've got over 250 rows, so i'm guessing that might be the issue?

Cheers,