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

Lucinda Bugbee ✭✭✭

03/13/25 in Formulas and Functions

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.

0 · Share on FacebookShare on Twitter

Answers

• 

  Paul Newcome Community Champion

  03/13/25

  Are you able to provide some screenshots for context? Are you trying to capture what the status was last week and then count them up by status?

  CERTIFIED SMARTSHEET PLATINUM PARTNER

  10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)

  Would you benefit from getting my help in person?

  0 · Share on FacebookShare on Twitter

Sign in

Try for free

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list