CountIFs Formula Help to Show Number of Resource Open, Closed and Overdue Tasks Across Multiple Acti

I need a COUNTIFS formula (I think this is the best option based on research) that calculates all of my technical resources task status for all of the projects. An example is below.

I have 4 current projects and 7 resources. Please see the screenshot for an idea of what I'm trying to accomplish on a Metrics sheet that totals info from the 4 projects.

Can I get help on creating a formula to count the types of tasks (Open, Closed, Overdue) for each resource (resource 1, resource2, resource3, and etc.) across all for Projects (project1, project2, project3, project4)?

Thank you for the help!

Find more posts tagged with

Formulas

IT & Operations

Project Management

Media & Entertainment

Comments

CB_OSG

BTW, in the screenshot, Resource 1 shows 100 in the open column but that formula is only referencing one project. Wanted to clarify.

Paul Newcome

Does each project have it's own sheet?

CB_OSG

Hello. Yes. Each project has its own sheet.

Paul Newcome

Then you will need to use your Project 1 Formula, Replicate it for Project 2, then add them together.

=COUNTIFS(Project 1 Formula) + COUNTIFS(Project 2 Formula) + COUNTIFS(Project 3 Formula) + ................................

Sign in to join the conversation!

Quick Links

Trending discussions

Is there a way to create a 3-digit padding for numbers
Hi all, and thanks in advance! I wanted to know if there was any way to create "padding" in Smartsheet. Basically I have account numbers, and a handful are still 2-digit, so they appear as TDL-17, TDL-67, etc. Most of the accounts are 3-digit numbers like TDL-180. I want something that will recognize whether it is 2 or 3…
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?