Counting rows from a certain date


Trying to create a formula to count rows that are from certain date onward (ie. 11/30/2020)


  • Heather Duff
    Heather Duff ✭✭✭✭✭✭

    Hi @Victoria Ganuelas

    Do you already have a date column? If so, try this:

    =COUNTIF([date column]:[date column], >=DATE(2020, 11, 30))

    If it's a cross-sheet formula, you'll want to use something like this, where {date} is the named reference for your date column in the source sheet:

    =COUNTIF({date}, @cell >=DATE(2020, 11, 30))

    Let me know if this works for you!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!