COUNTIF Date is past a specific date
Hey team - I have an auto generated "Submitted" column that automatically creates the date that the row items was submitted/created.
I'm an trying to create a sheet summary formula to count the number of rows that were created after 04/19/21.
I tried the following and it returns 0:
- =COUNTIFS(Submitted:Submitted, @cell > 4 / 19 / 21)
- =COUNTIF(Submitted:Submitted, @cell > 4 / 19 / 21)
There are at least 20 rows that were created after after 04/19/21.
Any ideas what I'm missing?
Answers
-
Try this...
=COUNTIFS(Submitted:Submitted, DATEONLY(@cell) > DATE(2021, 04, 19))
-
Hi @Paul Newcome - I get an INVALID DATA TYPE when I use that formula.
-
Ok. Try this then...
=COUNTIFS(Submitted:Submitted, IFERROR(DATEONLY(@cell), DATE(2021, 04, 18)) > DATE(2021, 04, 19))
Edited to correct a missing parenthesis.
-
Same thing @Paul Newcome - INVALID DATA TYPE when I use =COUNTIFS(Submitted:Submitted, IFERROR(DATEONLY(@cell), DATE(2021, 04, 18)) > DATE(2021, 04, 19))
-
That's odd.
Remove the formula completely.
Log out.
Clear your browser's cookies and cache.
Log back in.
Manually key the formula.
Lets see if that helps any...
-
Well that appeared to work, @Paul Newcome !
Thanks for hanging in there with me.
-
Great. On rare occasion I have found that there is (for whatever reason) latent data that hangs around on the back-end. If you know for a fact that a formula should be working but it isn't, I suggest taking those steps.
Typically when I have run into this issue is when I am using dates in a COUNTIFS (just a heads up).
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!