How to review a column of dates and count the rows that are not a date

I have a use case where I have a list of dates and need to count the number of rows that do not have a date in the column. For example,

12/01/23

12/02/23

12/03/23

Active

12/05/23

Not Active

12/07/23

(space or blank)

12/08/23

12/09/23

12/10/23

In this example, the number of non-dates in the column should be 3. I believe I need to use a ISDATE() function but for the entire column. Below is the formula I have that doesn't work in my source sheet.

=COUNTIFS({Hub Name}, [Hub Name]@row, {Node List - Node Activation Date}, <> ISDATE(@cell))

Where,

"Node List - Node Activation Date" is a list of dates in a column (with a date property) on my target sheet that is in the list of dates format like the example above.

"[Hub Name]@row" on my source sheet should match the "Hub Name" on my target sheet.


Thank you.

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!