COUNTIFS giving #Incorrect Argument Set



I'm trying to create a data set that counts the number of deliverables due within a week of the year.

What I could like to do is to count the number of items checked in the "deliverables" box, that falls before/within a week ending finish date. The sheet I'm doing this in looks like this:

The formular I am using is: =COUNTIFS({Design Schedule Range 4}, =1, {Design Schedule Range 1}, <(Date@row + 1))

Where "Design Schedule Range 4" is the column titled "Deliverable" in the first screenshot and "Design Schedule Range 1" is the "Finish" column in the same screenshot. Any tips/ideas? I am able to do the arguments separately but it's seems to be when I put them together that I have issues.


  • KPH
    KPH ✭✭✭✭✭✭

    If the formula works when the criterion are separated but not when combined it might be due to differences in the ranges you selected. Can you check that Design Schedule Range 4 and Design Schedule Range 1 refer to the same size and shape of cells (ideally one full column in each)?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!