% of checked off tasks by task category
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!
Help Article Resources
Check out the Formula Handbook template!