Percentage Complete not totaling 100%
This Month-End 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 48-92 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!