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



Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!