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?