COUNTIF Date is past a specific date

jmo
jmo ✭✭✭✭✭✭

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!