nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

COUNTIFS in Sheet Summary utilizing a Contact Card column

Tim Effrig

I am trying to create a sheet summary, where the field is a formula that relies on a contact card within a column. However, it keeps returning a result of "#NO MATCH". The columns involved are, 1:) Priority (symbol column) for Up, Unchanged, and Down, and 2:) Contact Card column. I am trying to get a sheet summary formula in a field that shows "if the Priority is "Up", and the "Senior RVP" column is a contact card (NAME), provide a count of Priority "Up" for that contact card (NAME)

It should be known that the "Senior RVP" contact card is doing a vlookup off a seperate reference sheet, so the "Senior RVP" column is a return vlookup result.

The formula I am using in the Sheet Summary field is:

=COUNTIFS(Priority:Priority,"Up", [Senior RVP]:[Senior RVP], "NAME")

Result = #NO MATCH

Find more posts tagged with

Sheets

Formulas

Sheet Summary

Countif

Accepted answers

All comments

Paul Newcome

Are you able to provide some screenshots for context (mock data if necessary)? Is the data the VLOOKUP is referencing stored as a contact in a contact type field?

Tim Effrig

Thanks for the reply! Yes, the data in the vlookup is stored as a contact card in a separate sheet. I can mock up data, but it'll take me a little bit unfortunately, what are you looking for in particular?

Paul Newcome

Sometimes there are context clues based on how things are displayed.

But before you do that…

Is there a #NO MATCH error in any of the cells being referenced by the COUNTIFS? If the VLOOKUP is outputting that error in even once cell, the COUNTIFS will pull that error in as well.

If you see any rows that are like that, try an IFERROR on your VLOOKUP.

=IFERROR(VLOOKUP(…………….), "")

Tim Effrig

There are zero errors or #NO MATCH errors in the reference sheet for my VLOOKUP.

Paul Newcome

Not in the reference sheet. In the column that actually houses the VLOOKUP. The same sheet your COUNTIFS is in.

Tim Effrig

Oh gotcha, sorry for the confusion. I didn't notice it, but yes there are a few #NO MATCH items. Would that be the cause potentially?

Tim Effrig

I updated the formula in the column that houses the VLOOKUP to the following:

=IFERROR(VLOOKUP(RVP@row, {Senior RVP List-Primary Column:Senior RVP}, 2, 0), "")

So the return value equals no value in that VLOOKUP reference column field. When I go to the sheet summary formula, it got rid of the "#NO MATCH value, but it is not giving me an accurate count of the count result (i.e. There should be 25 in "Up" symbol status, but it is actually showing as "0" (zero)

Paul Newcome

Change the sheet summary formula to this for now:
=COUNTIFS([Senior RVP]:[Senior RVP], "NAME")

Does that also output zero?

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.