Count IFS and NOT(IsBlank


Good morning!

I am attempting to use a sheet to count instances on another sheet and keep getting an Incorrect Argument error on the rows that should be counted.

I am counting the number of jobs with a particular type where one column is blank and another is not blank.

So count by Job Type, if Engineering Completion Date is blank, and Division Name is not blank (this is to weed out the additional rows on the sheet with no data in them). I have attached a screenshot below. For other branches I can simply put Division is equal to "X" but this branch has two locations so I thought it may be easier to just use "Not Blank".

Thanks for your help!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!