COUNTIFS on 2 check box columns, 1 checked, 1 unchecked

Jon Stikka
Jon Stikka ✭✭✭
edited 12/09/19 in Formulas and Functions

I am trying to write a formula for a sheet summary where an "Over Due" check box is checked (driven by a due date column), and a "Done" check box is not checked...

=COUNTIFS([Over Due]:[Over Due], 1, Done:Done, 0)

#Invalid Operation...

I originally tried to run a countifs based on Done = 0, and Due Date < TODAY, but learned you can't run a countifs using a date field, apparently.

what am I doing wrong?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!