COUNTIFS formula for any future date?


Hi all,

I am trying to create a COUNTIFS formula that counts if the due date column on another sheet is today or any future date.

I tried =COUNTIFS({due date column's range}, >=TODAY()), but it is not working.

Any advice would be appreciated! Thank you.


Best Answer

  • Samuel Mueller
    Samuel Mueller Overachievers
    Answer ✓

    try this =COUNTIFS({due date column's range}, @cell>=TODAY())

    Also, keep in mind that the today formula does not update unless the sheet is opened and saved everyday. There are some workarounds to this issue.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!