How to create a Sheet Summary for the last 7 days ?

I am trying to find out how to summarize (count) the number of items that have been completed in the last 7 day? but my formula is reading 0? i think there might be a syntax error

=COUNTIFS(Complete:Complete, "0", Created:Created, TODAY(-7))


  • Mike TV
    Mike TV ✭✭✭✭✭✭

    @Brendan Ginns

    Try this:

    =COUNTIFS(Complete:Complete, "0", Created:Created, AND(@cell >= TODAY(-7), @cell <= TODAY(-1)))

    This should work but if your column called Created is the created date and not the completed date that could be part of your problem. Also, if you want to include items completed today in this then at the end for TODAY(-1) change it to just TODAY()

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!