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
-
Try this instead =COUNTIFS({Hub Name}, [Hub Name]@row, {Node List - Node Activation Date}, NOT(ISDATE(@cell)))
-
That did it! Thank you.
Answers
-
Try this instead =COUNTIFS({Hub Name}, [Hub Name]@row, {Node List - Node Activation Date}, NOT(ISDATE(@cell)))
-
That did it! Thank you.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!