Is there a way to count cells that contain dates in Smartsheet, like Excel's COUNTA function?
Best Answers
-
There are a number of ways to count Dates.
You can use COUNT(). This counts all cells except empty ones
If you only want to count dates, you can use COUNTIFS
=COUNTIFS(count range, ISDATE(@cell))
If you provide more info or context, I can give you a specific formula
Kelly
-
This worked! Thanks so much @Kelly Moore
I previously used COUNT() but then this no longer worked when I needed to add text to cells in the column. I also tried ISDATE but forgot about (@cell) since I'm still learning formulas in Smartsheet.
Veronica
Answers
-
There are a number of ways to count Dates.
You can use COUNT(). This counts all cells except empty ones
If you only want to count dates, you can use COUNTIFS
=COUNTIFS(count range, ISDATE(@cell))
If you provide more info or context, I can give you a specific formula
Kelly
-
This worked! Thanks so much @Kelly Moore
I previously used COUNT() but then this no longer worked when I needed to add text to cells in the column. I also tried ISDATE but forgot about (@cell) since I'm still learning formulas in Smartsheet.
Veronica
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!