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")

Example:

Dave: works

Sarah: works

00131851: counts zero

John: works

Find more posts tagged with

Accepted answers

Kleerfyre

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.

All comments

Kleerfyre

Is your numbers in quotes in your formula? If so, remove the quotes.

DDPayPal

https://community.smartsheet.com/discussion/comment/378570#Comment_378570

No, no quotes around the number. There are quotes around the second criteria which would always be one of two text options they select on another sheet. This first criteria being their User ID is almost always text, in fact this is the first time I've seen someone with a number for an ID. Anyway no quotes for that criteria.

DDPayPal

Adding more context:

Formula 1: =COUNTIFS({EFX NPM Quality Evaluations Range 1}, Manager@row, {EFX NPM Quality Evaluations Range 3}, "Scheduled Coaching")

Formula 2: =COUNTIFS({EFX NPM Quality Evaluations Range 1}, Manager@row, {EFX NPM Quality Evaluations Range 3}, "Integrated Coaching")

Other sheet:

Kleerfyre

DDPayPal

https://community.smartsheet.com/discussion/comment/378576#Comment_378576

I think I agree. No SS integration with our systems so it would just be a matter of the one person (far as I know) following a special process. Thanks for the suggestion!

Kleerfyre

No problem! Sometimes the easiest solution is a simple process change and not reworking everything for one issue.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.