CountIF issue

=COUNTIF({CBG Cold Spring, MN Items List Range 2}, {CBG Cold Spring, MN Items List Range 1}, >DATE(2024, 1, 1))
Hello i am trying to find non blank in a column based on the criteria that is after 1/1/2024 and this is not working. It says incorrect argument set.
Answers
-
The COUNTIF function for Smartsheet only takes a single range and one criterion, looks like you've got 2 ranges involved in the formula you have written. I recommend looking at the COUNTIF and the COUNTIF function pages to help you re-write your formula:
-
I agree with @Courtney S. , it would also help to know if you want it to count if BOTH ranges are blank or if only one of them is. Depending on that answer you might also need to look into the AND/OR functions.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!