COUNTIFS formula for any future date?

Options

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.

Tags:

Best Answer

  • Samuel Mueller
    Samuel Mueller Overachievers
    Answer ✓
    Options

    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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!