Formula to count weekly volume


Hi everyone,

I am trying to add a sheet summary formula that counts the total amount of new entries that were created in the last 7 days, and closed entries from the last 7 days.

I've tried this one for created entries but it doesn't seem to do the trick.

=COUNTIFS([Created Date]:[Created Date], <= TODAY(7), [Created Date]:[Created Date], >TODAY())

I suck at formulas! Lol


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!