Report Tasks within this week
Hello. How to I create a report to pull tasks for this week, or next week dynamically without having to change the dates in the filter?
Best Answer
-
The easiest method is to use the Filter option in the report, "Is in the next", and put the number of days, 7 for example, to capture tasks that are coming due in the next 7 days.
If you need it to be this week or next week, create helper columns to identify when this week and next week ends and then compare the task date to those dates.
Answers
-
The easiest method is to use the Filter option in the report, "Is in the next", and put the number of days, 7 for example, to capture tasks that are coming due in the next 7 days.
If you need it to be this week or next week, create helper columns to identify when this week and next week ends and then compare the task date to those dates.
-
I think help columns would do the trick. I wonder if there is a function i can use to return the week of the year
-
Use:
WEEKNUMBER([Your Date]@row)
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 58 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
