% of checked off tasks by task category
Hello!
I'm attempting embed a tracker for understanding progress completion by different categories within a project plan. See screenshot below!
This formula is supposed to count if a task is checked off within the hub and spoke category / total number of items (checked or checked) within that category to give me a percent complete. Does that make sense? The formula i have in the screenshot is for the total percent complete (regardless of task category) and that seemed to work but I cant figure out the percent by category addition!
Thanks for your help!
Best Answer

You should be able to do this with a similar structure to what you already have. Something like this should work:
=COUNTIFS(Done15:Done73, @cell = true, [Task Category]15:[Task Category]73, "Education & Research") / COUNTIF([Task Category]15:[Task Category]73, "Education & Research")
Where the first COUNTIFS is counting anytime Done in the range you defined is checked AND the task category is the category you're looking for (for the example I used Education & Research, but you can change this to whichever category you're looking for).
The denominator is a count of how many tasks fall into your category. In this example how many tasks are Education & Research. That should give you the percentage of tasks checked Done in that category.
Answers

You should be able to do this with a similar structure to what you already have. Something like this should work:
=COUNTIFS(Done15:Done73, @cell = true, [Task Category]15:[Task Category]73, "Education & Research") / COUNTIF([Task Category]15:[Task Category]73, "Education & Research")
Where the first COUNTIFS is counting anytime Done in the range you defined is checked AND the task category is the category you're looking for (for the example I used Education & Research, but you can change this to whichever category you're looking for).
The denominator is a count of how many tasks fall into your category. In this example how many tasks are Education & Research. That should give you the percentage of tasks checked Done in that category.

@David Tutwiler That did it thank you!

Awesome, glad it's working.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 351 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 135 Brandfolder
 127 Just for fun
 128 Community Job Board
 443 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!