Report Development by Last Week/Current Week/Next Week
I have several projects built out on separate Smartsheets. Some of the tasks on these projects have durations that extend for longer than a week. I would like to develop reports that show the working time spent for last week, the current week, and next week.
For example, if I have a task that starts on Thursday (this week) and extends to the following Tuesday. I need two days of the duration to display in the "Current Week" report, and two days to display in the "Next Week" report. I cannot seem to figure this out. When I create the filter in the report for the specific weekly dates, none of the time displays in the current week and all four days are in the following week. Thus, skewing my reports.
Can you please provide guidance on how to resolve? Or, perhaps a better way to display time worked on projects during specific last, current, and next week intervals?