Multiple nesting help!

So I have 6 survey questions with response options of "below expectations, meets expectations, and exceeds expectations." I need it to tell me how many below expectations for question 1 are in each region and so forth for each response option and region.

So far this formula works great!

=COUNTIFS([Delivery Timeliness]:[Delivery Timeliness], [Delivery Timeliness]@row, Region:Region, Region@row)

But it fills in numbers for BLANK response cells with just Region counts of how many times a region is entered as a default. I've tried this:

=COUNTIFS([Delivery Timeliness]:[Delivery Timeliness], [Delivery Timeliness]@row, Region:Region, Region@row, IF(ISBLANK([Delivery Timeliness]:[Delivery Timeliness], "Blank", "Not blank")))

=COUNTIFS([Delivery Timeliness]:[Delivery Timeliness], [Delivery Timeliness]@row, Region:Region, Region@row, IF(ISBLANK([Delivery Timeliness]@row), "Blank", "Not blank")))

However, it keeps coming back saying INCORRECT ARGUMENT SET. What do I do great Smartsheet Community?...

Find more posts tagged with

Construction

Sheets

Formulas

functionality

Automations

Accepted answers

All comments

Jon Mark H

Hey @Loghen.Christyne !

It looks like this should get that column showing properly:

If Delivery Timeliness is blank - it will just show a 0 in this column

=COUNTIFS([Delivery Timeliness]:[Delivery Timeliness], AND(@cell = [Delivery Timeliness]@row, @cell <> ""), Region:Region, Region@row)

Let me know if this solves your problem or if you have any other issues that need help!

-Jon Mark

Loghen.Christyne

Hey @Jon Mark H!

You are a genius! Thank you, that worked perfectly!

Jon Mark H

Glad I could help!

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.