count one column based on a different filtered column
Hello,
I have a list of staff names in one column and another column with task statuses (Not Started, In Progress, Complete). I'd like to find how many In Progress and Not Started tasks each staff member has. I've tried COUNTIF and COUNTIFS but can't quite get the formula right. All of the examples I'm finding are looking for blank cells and none of mine are blank. I know this is incorrect but it's the closest I've come.....
=COUNTIF({Credentialing Tasks - Staff}, {Credentialing Tasks Status<>"Complete"})
Any ideas please?
Thank you!
Comments
-
The formula listed above has the } in the wrong place but hopefully you understand what I'm trying to do.... Thanks again!
-
What is the actual column name without the row reference?
Category
or
Category 18
-
The column name is "Assigned To".
-
-
Whwat are the steps you are taking to create your cross sheet references?
Are you able to post some screenshots with confidential/sensitive data removed, blacked out, or replaced with "Dummy Data"?
-
I've attached two screenshots. One is the tracker where the data is being kept and added to. The other is the Metrics sheet where I'm trying to put the formula. Thanks for your help!
-
What is the column name on your metrics sheet where your staff names are listed?
-
Try "=COUNTIFS({Credentialing Tasks - Staff},[Assigned To]@row,{Credentialing Tasks Status},"Complete")
Make sure the 2 sheet references are referencing the entire columns and not a specific cell. By doing an entire column, this will look for everything that matches your requirements.
-
No column name...see attached...
-
This gave me another "Unparseable" error.
-
"Category" is your column name. Try this...
=COUNTIFS({Credentialing Tasks - Staff}, Category@row, {Credentialing Tasks Status}, @cell <> "Complete")
-
It works! Thank you so much for your help!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!