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.
