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
-
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?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67K Get Help
- 441 Global Discussions
- 154 Industry Talk
- 502 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 79 Community Job Board
- 512 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!