How to filter anything that has been marked complete in the last 30 days
I am trying to set up a chart so that any project that has been marked at complete in the last 30 days will show up in there. I did this by filtering in the report for any due date that is in the last 30 days, AND has also been marked complete. But I am realizing now that it may not be the best solution, as sometimes people mark their projects complete before the actual due date. Here you can see that someone has completed a project ahead of time, but it doesn't show on the chart. Is there a way to change my current filtering to help this? Or would I need to create a helper column in the actual project that automatically logs when the project was completed. If so, how would I do this? Also attaching a screenshot of the template for our projects. Thank you!
Best Answer
-
You would need to set up a date type column in the source sheet(s) along with a Record a Date automation set to run when the % complete changes to 100%. Then you would reference this date in your report filter.
Answers
-
You would need to set up a date type column in the source sheet(s) along with a Record a Date automation set to run when the % complete changes to 100%. Then you would reference this date in your report filter.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives