CountIfs one column is not blank and the other one is


I'm trying to count rows that have a date in one cell but is blank (no checkmark) in the other. Is that possible? I've done multiple iterations, all unsuccessfully. Here's the last one I've tried:

=COUNTIFS([Date Tip Sheet Submitted]1:[Date Tip Sheet Submitted]1129,<>, [Tip Sheet Archived - No longer relevant]1:[Tip Sheet Archived - No longer relevant]1129 ISBLANK(@cell))

Essentially I'm trying to create a running total of how many documents have been submitted (column is set up as a Date format) but still waiting for approval (column is a checkmark format). I'd be grateful for any help!!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!