COUNTIFS Date is before today and another field is blank

Hi

Can anyone help mw with my need to calculate the following for a sheet summary.

How many rows have a target date in the past AND the Date Completed for the same row is blank

This is not working so I suspect I have to add in a @row type value somewhere

=COUNTIFS([Date Completed]:[Date Completed], "",[Target Date]:[Target Date],<=TODAY)

Both criterion work on their own but not when joined.

Thanks

Graham

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!