Trying to count the errors on the sheet

Samuel Dowdy Jr.
Samuel Dowdy Jr. ✭✭✭✭✭✭
edited 11/07/22 in Formulas and Functions

=COUNTIF(Location:Location, "NO MATCH")

Instead of getting a number im getting #NO MATCH.


Answers

  • Christian G.
    Christian G. ✭✭✭✭✭✭

    You can catch the error and change it to a string that can then be used with a match.

    =Iferror([your match formula here],"NO MATCH")

    Then:

    =COUNTIF(Location:Location, "NO MATCH")

    Keep in mind that this will change ALL errors to "no match", Event the "#Invalid Data type" that we see here

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!