Is there a way to COUNTIF checked boxes, but have the formula skip over boxes with an error?
I have successfully implemented a formula in a sheet summary that COUNTIFS checked boxes in a column but because of the nature in which this sheet is being used, some of the checkboxes that I am counting have temporary #NO MATCH errors due to information not yet being available from other sheets which is thus causing the sheet summary field to return #NO MATCH as well. Is there a way to have my COUNTIFS not count rows that have an error so it only counts the checked boxes? Thank you!
Best Answer
-
You could use an IFERROR on the formula within the checkboxes to replace the error with a blank or even text that replicates the error. Even if it is the text, since it is generated text and not an automatic error, your COUNT formula should work.
Answers
-
You could use an IFERROR on the formula within the checkboxes to replace the error with a blank or even text that replicates the error. Even if it is the text, since it is generated text and not an automatic error, your COUNT formula should work.
-
That worked perfectly, thank you!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!