Count # of cells approaching a date for sheet summary

I'm trying to create a sheet summary field that counts the number of cells in a column that are less than a week from the date in the cell.

This is what I've tried:

=COUNTIF(Off-Site to On-Site Return Estimation:Off-Site to On-Site Return Estimation, TODAY(<7)

Thank you for any help!

Best Answer

  • Isis Taylor
    Isis Taylor ✭✭✭✭✭✭
    Answer ✓

    @rbattista Got it. This works on my sheet.

    =COUNTIFS([Start Date]:[Start Date], >=TODAY(), [Start Date]:[Start Date], @cell <= TODAY() + 7)

    Isis Taylor

    🎓️ Core App and Project Management Certified 🏅

    🌟Peer Connect, Mobilizer, and Early Adopter Program

    Business Analyst Senior

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!