COUNTIFS on a cross sheet formula with ISDATE function


=COUNTIFS({PBR}, main@row, {request date}, YEAR(@cell) = 2020)

The above works fine, but when I add an ISDATE function (below), fails.

=COUNTIFS({PBR}, main@row, {request date}, YEAR(@cell) = 2020, {complete date}, ISDATE(@cell))

What am I doing wrong? I only need to count records with a completion date. I've also played with {complete date}, NOT(ISBLANK(@cell) with no success.

Seems easy, so I'm sure I'm missing something simple. Help!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!