Percentage Complete not totaling 100%
This MonthEnd Checklist below has the same countif formula in both rows. January totals 100% and February only 96%. What am I missing?
This is the formula
It's counting the check boxes.
Darla Brown
What you meditate on, you empower!
Overachiever  Core Product Certified  Mobilizer  EAP
Best Answer

Well. Not sure what happened. But it resolved itself. We are at 100% now. lol
Darla Brown
What you meditate on, you empower!
Overachiever  Core Product Certified  Mobilizer  EAP
Answers

That does seem odd. Here are a few troubleshooting steps that may assist in determining where the problem may lie:
Use this formula to see how many items are detected as complete:
=COUNTIF(Complete48:Complete92, 1)
Then this one to see how many total items are recognized:
=COUNT(Complete48:Complete92)
If those two formulas provide different results (which they should since your result is not 100%), use this one to get a list of all tasks that are recognized as complete. Anything missing will show you which cell(s) are causing your issue:
=JOIN(COLLECT(Task48:Task92, Complete48:Complete92, 1), ", ")

Hi,
That formula returned text and not a number. So cannot use it.
The first part of my formula returned 43, which is correct. The second part returned 45, which makes no sense because there are only 43 rows to count. All boxes are checked.
Darla Brown
What you meditate on, you empower!
Overachiever  Core Product Certified  Mobilizer  EAP

Did you verify that rows 4892 are the correct range?
The last formula would tell you which rows are missing in the count. Are you able to add a temporary column to plug the formula in there, or add it to the sheet summary?

Yes. This formula is the same formula I use in 5 other sheets. This is the only one that is not working. It makes zero sense.
43 rows. 43 checkboxes. Everything is verified. Works for January. Does not work for February
Darla Brown
What you meditate on, you empower!
Overachiever  Core Product Certified  Mobilizer  EAP

Well. Not sure what happened. But it resolved itself. We are at 100% now. lol
Darla Brown
What you meditate on, you empower!
Overachiever  Core Product Certified  Mobilizer  EAP
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 445 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!