Counting rows from a certain date

Options

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

Answers

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭
    Options

    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!


    Best,

    Heather

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!