Multiple nesting help!

Loghen.Christyne

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?...

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!