How to create a formula for work completed last week based on a status

I have a status column in my sheet and want to understand what work was processed last week for each status. I have a Modified Date column in my sheet and assume I can use this, but don't know how to capture the information.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!