COUNTIFS not counting when criteria is a numeric match

I might be missing something basic about formulas, but I have a COUNTIFS formula that counts the number of rows associated with an employees ID and another criteria. It works for all employees except one, who has a numeric ID instead of text. Is this something COUNTIFS just cannot do?

Formula: =COUNTIFS({employee ID on other sheet}, employee ID@row, {other criteria on other sheet}, "criteria")


Dave: works

Sarah: works

00131851: counts zero

John: works

Best Answer

  • Kleerfyre
    Kleerfyre ✭✭✭✭✭✭
    Answer ✓

    I would find out who posted that entry and find out the name that it should be and just put in the name. Then I would make sure that the ones entering this data know to use the person's actual name. That way you don't have to fix something for one random issue.

    Jonathan Sanders, CSM

    "Change is always scary because it is unknown, but facing the unknown is what makes us stronger."


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!