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, [email protected])

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, [email protected], IF(ISBLANK([Delivery Timeliness]:[Delivery Timeliness], "Blank", "Not blank")))

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

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



Answers

  • Jon Mark H
    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, [email protected])


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


    -Jon Mark

  • Hey @Jon Mark H!

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

  • Jon Mark H
    Jon Mark H ✭✭✭✭

    Glad I could help!