Show tasks completed in calendar week?

Is there a way to count the number of tasks completed in a calendar week, Sunday-Saturday?

I have a metric that shows the number of items completed in the last 7 days (>TODAY(-7)) and I've been asked if the metric can show items completed in the calendar last week, meaning Sunday to Saturday, rather than a rolling last 7 days.

Is that possible?



Andrea Zenner

Program Manager | Infrastructure & Operations

Apogee Enterprises

EAP | Mobilizer | Core Product Certified | Superstar



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!