Summary Count of Status by Assigned Person

I have been racking my brain for a bit to figure out a formula for a summary sheet that will give me a count of each status (not started, in progress, complete, at risk) by the user assigned. I am trying to pull this information from my project sheet. I have a summary count for each status but I cannot seem to add the additional criteria of the assigned person in addition to the status to get that count. Can anyone offer some advise or help?

Thanks,

Robert

Find more posts tagged with

Formulas

Project Management

Comments

Andrée Starå

Hi Robert,

It would look something like this.

=COUNTIFS({Range - Assigned To}; Assigned@row; {Range - Status}; "In Progress")

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

rpyonker

Thank you Andree, the formula that you put in was exactly what I needed. I had been using the CountIF formula but the CountIFS worked perfectly. Thanks for you help.

Robert

Andrée Starå

Excellent!

Happy to help!

Rhett

Hi there - I am not understanding how to use this COUNTIFS formula above. I am in the process of creating a SmartSheet dashboard for my team from an intake tracker we have. I would like to use the metrics widgets which require sheet summary formulas.

Problem - I am trying to create a sheet summary of how many current tasks are assigned to a specific resource - we have 9 teammates that are assigned to these tasks but the assigned column is by email and we have 5 different priority categories. is there any way I can get some help on the below formula on how to actually input it? Currently I am getting unsparseable

=COUNTIFS({Range - Assigned To}; Assigned@row; {Range - Status}; "In Progress")

where do I input the teammates email in this and the priorities? Status could work to for the example and I can reverse engineer.

it's an intake tracker with constant tickets being assigned to different teammates

Andrée Starå

Hi @Rhett

I hope you're well and safe!

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

Be safe and have a fantastic weekend!

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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…