Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Dynamic Dates
I am creating task reports for our team that pulls tasks from multiple sheets and aggregates them into one, easy to read report. I'm using reports because I want to apply date filters and structure task reports to show all outstanding tasks (past due and due today) and upcoming tasks (tasks due within the next week).
I thought I created a report to do this, but the date filter turned out to be static and need to be updated daily in order to function properly. Am I doing something wrong is there not a way to set the date filter to change dynamically?
Comments
-
Hi Linn
In reports you have the date choices of ... In the past, or Today or in the next xxxxx?
So you should be able to get just what you need?
Let us know if not and we can review the issue together?
Regards
RichardR
-
Ah I see the problem. When I selected the date range, I used "Is less than" and then selected "Today" from the calendar. My bad. Thank you for clarifying that for me.
