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.
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?