Countif "#INVALID OPERATION"
Hi
Im trying to count all "#INVALID OPERATION" in order to catch if someone has enter an invalid character etc in a cell which needs to be added up.
I have tried multiple things without success.
The following is using the New "contains" function which returns a larger count than it should.
=COUNTIF({O_Eq_Total_Hrs}, (CONTAINS("INVALID", {O_Eq_Total_Hrs})))
Any help would be appreciated
thanks
Comments
-
I would modify the formula creating the error by wrapping it with an IFERROR function.
=IFERROR(INSERT YOUR FORMULA WITHOUT THE EQUAL SIGN HERE, "Error")
Then you could count if "Error" was appearing in the results. I don't think errors are actual data that can be counted. Wrapping the error in the IFERROR formula will give you data to count.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!